Spreadsheet Features

Spreadsheet Features

1. variables

   • identifier
   • associated with a particular cell
   • cell reference of named cell

2. formulas

   • a calculation
   • contains cell references or values
   • uses +, -, * /

3. rules

   • set of procedures that must be followed
   • validation rule
   • sequence of events, e.g. in a calculation

4. functions

   • complex formula
   • uses reserved words
   • built into spreadsheet
   • e.g. SUM