Spreadsheet Software

Spreadsheet Software

1. Benefits of using Spreadsheets

   • "What if" investigations
   • Accurate Calculations
   • Automatic Recalculations
   • Easy to produce graphs and charts

2. Components of Spreadsheets

   • Labels
   • Data
   • Formulas

3. Functions

   • Specialised Calculation that the software has memorised
   • =AVERAGE(A3:A10)
   • =SUM(E3:P3)
   • =MAX(E4:E9)

4. Cell Referencing

   • Relative Cell Referencing
     • The selected cells will move down as the cell is copied
     • Can make calculations wrong if you need to use absoloute
   • Absoloute Cell Referencing
     • Chosen cell will stay the same value when the cell is copied
     • e.g: $A$4
     • Exam Questions
       • 'Fixes the value'
       • Will usually show up
       • Absoloute Cell Referencing - it fixes the value when the cell is replicated.

5. Formatting Data

   • Data
   • Integer
   • Percentage
   • Currency
   • Cell Merging

6. Spreadsheet Formatting

   • Alignment
   • Text
   • Borders
   • Roating text
   • Cell merging