Spreadsheets

Spreadsheets

1. Benefits of Spreadsheets

   • perform 'what if' investigations
   • Automatic recalculations
   • Accurate Calculations
   • Easy to produce Graphs and charts

2. Components of Spreadsheets

   • Labels
   • Data
   • Formulas

3. Functions

   • Average
   • Sum
   • specialised calculations that can be memorised

4. Formatting Data

   • Data
   • Integer- Number
   • Percentage
   • Currency
   • Text

5. Formatting spreadsheets

   • Alignment- Left, Right or Centre
   • Text-Colour, Font, Size
   • Borders
   • Rotating text
   • Cell Merging