Spreadsheets REVISION

Spreadsheets REVISION

1. ADVANTAGES

   • + you can perform 'what-if' investigations
     • + automatic recalculation
       • + accurate calculation
         • + easy to provide graphs and charts
   • This is on EVERY EXAM

2. COMPONENTS OF A SPREADSHEET

   • Labels
     • Used for titles, headings, names and for identifying rows or columns of data
     • Data
       • Values that you enter (text or numbers)
   • Formulas
     • Used to perform mathematical calculations

3. FORMATTING

   • Data
     • integer
     • percentage
     • currency
     • text
     • date/time
   • Cells
     • allignment
     • borders
     • rotating text
     • font
     • cell merging

4. FUNCTIONS

   • average
   • median
   • sum
   • min
   • max
   • count

5. CELL REFERENCES

   • relative
     • MOVE
   • absolute
     • STAY