Spreadsheets

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

Workbook

              A workbook is a file which contains one or more spreadsheets

Daily uses

Spreadsheets are used on daily basis to balancing a checkbook, calculating car loans. calculating grades, and house hold budgets.

Designing a spreadsheet

Cell – individual locations on a spreadshee

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 specifics

Cell Range:

  • A4:A16 refers to a group of adjacent cells
  • 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