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?
- 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
- 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.
- A specific location
- Cell A4 = Cell Address
- It is the Column letter and Row number
- The cell address is also called the cell reference
- The cell that is selected
- It is the cell that is ready to receive information