Slide

01-Oct-08

Book to PC

A spreadsheet is the computer equivalent of a paper ledger sheet. It consists of a grid made from columns and rows. It is an environment that can make number manipulation easy and somewhat painless.

LAB 1 MS Excel Data Manipulation

MIS Lab

The math that goes on behind the scenes on the paper ledger can be overwhelming. If you change the loan amount, you will have to start the math all over again (from scratch). But lets take a closer look at the computer version.

2

Experimentation

Let the COMPUTER do the calculations !

Rows and Columns

Spreadsheets are made up of Columns Rows and their intersections are called cells In each cell there may be the following types of data Text (labels) Number Data (constants) Formulas (mathematical equations that do all the work)

NO erasers! NO new formulas! NO calculators!

3

4

COLUMN

In a spreadsheet the COLUMN is defined as the vertical space that is going up and down the window. Letters are used to designate each COLUMN'S location In the above diagram the COLUMN labeled C is highlighted.

ROW

In a spreadsheet the ROW is defined as the horizontal space that is going across the window. Numbers are used to designate each ROW'S location In the above diagram the ROW labeled 4 is highlighted

5

6

1

01-Oct-08

CELL

CELL is defined as the space where a specified row and column intersect. Each CELL is assigned a name according to its COLUMN letter and ROW number. In the above diagram the CELL labeled B6 is highlighted.When referencing a cell, you should put the column first and the row second.

7

Types of Data

Labels - (text with no numerical value) Constants - (just a number -- constant value) Formulas* - (a mathematical equation used to calculate)

data types LABEL CONSTANT FORMULA examples Name or Wage or Days 5 or 3.75 or -7.4 =5+3 or = 8*5+3 descriptions anything that is just text any number math equation

8

Labels in Excel

Labels are text entries. They...