Tuesday, February 26, 2008

Basic of Spreadsheet

So let's get started digging into what makes a spreadsheet work. 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)
Take a look at the explanations of each of these.
Remember there will be a short quiz later on so if there is something you need to take notes on, TAKE NOTES ON IT!

What is 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.

picture of column

In the above diagram the COLUMN labeled C is highlighted.

What Is 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.

picture of row

In the above diagram the ROW labeled 4 is highlighted.


What is Cell?

In a spreadsheet the 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.

picture of CELL

In the above diagram the CELL labeled B6 is highlighted. When referencing a cell, you should put the column first and the row second.


No comments: