Friday, February 26, 2010

notes

Spreadsheets can contain
  • Values such as numbers and dates
  • Labels such as column and report headings that explain what the values mean
Relative, so they refer to different cells when they are copied
Absolute so the formula references never change when they are copied
automatic updates
Functions-automate complex calculations
Macros store keystokes and commands so they can be played back automatically
templates offer ready-to-use worksheets with labels and formulas already entered