Spreadsheet Software

Spreadsheet Software

1. Structure

   • Data
   • Labels
   • Formulas

2. Advantages

   • Accurate calculations
   • Automatic recalculations
   • 'What if' investigations
   • Easy to produce graphs and charts

3. Cell referencing

   • Relative
   • Absolute

4. Formats

   • Font type, font size, font colour, etc.
   • Bold, underline, italic, etc.
   • To hold certain types of data (e.g. date)
   • Cell border, background colour, etc.

5. Functions

   • Are specialist calculations
   • AVERAGE
   • COUNT