Spreadsheet (or Worksheet)

- An arrangement of cells in columns and rows used to organize, analyze, calculate, and report information, usually in numerical form.


- A file which contains one or more spreadsheets.

Daily Uses of Spreadsheets:

- Balancing a checkbook

- Calculating car loans

- Calculating student grades (helping students keep up with their grades)

- Household budgets

Why would a business use spreadsheets?

- Payroll

- Financial statements for a business (profit/loss)


- individual locations on a spreadsheet


- identified by letters of the alphabet (vertical)

- Column A refers to all of the contents in a vertical range of cells in the first column of the spreadsheet.


- identified by numbers (horizontal)

- Row 3 refers to all of the contents in a horizontal range of cells on Row 3

Cell Range

- A4:A16 refers to a group of adjacent cells

- A Range is a group/block of cells

- Example: A6:E16 refers to a range of cells in a specific spreadsheet.

Cell Address

- A specific location

- Cell A4 = Cell Address

-  It is the Column letter and Row number

- The cell address is also called the cell reference

Active Cell

- The cell that is selected

- It is the cell that is ready to receive information

Comment Stream