Spreadsheets

A spreadsheet is an arrangement of cells in columns and rows used to organize, analyze, calculate, and report information, usually in numerical form.

spreadsheets are for: Balancing a checkbook, loans, Calculating grades, budgets

spread sheets are used by and why: business for Payrolls and Financial statements, car owners for car loans.

Column— 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.

Row— 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.
  • Comment Stream