Spreadsheet

Spreadsheet

1. Benefits

   • Automatic recalcuation
   • Graphs/charts can be drawn
   • Replication (drag the formula down)
   • What-if calculations
   • Formulae can be stored and resued
   • Calculations involving large numbers are possible
   • Fill feature to copy recently used formulae

2. Relative cell referencing

   • When you drag a formulae down you use the cells relative address

3. Absolute cell referencing

   • Uses dollar signs to change the relative address but not the absolute address