Spreadsheets

spreadsheets are an arrangement of cells in columns or rows, used to organize, analyze, calculate, and report information, usually in numerical form. Spreadsheets are used to balance checkbooks, calculate car loans, calculate student grades, and household budgets. Businesses use spreadsheets for payroll, and financial statements ( profit/loss).

Workbook

workbook is a file which contains one or more s

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.
  • Designing a Spreadsheet

    Cell – individual locations on a spreadsheet

    (intersection of a row and column)

    §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

  • Cell A4 = Cell address
  • It is the Column letter and Row number.
  • The cell address is also called the cell reference.
  • spreadsheets
    Designing a spreadsheet

    Comment Stream