Spreadsheets

Spreadsheets

1. Benefits of using spreadsheets

   • You can perform 'what if' investigations- you can make changes to the spreadsheet values to see what happens.
   • Automatic recalculation- when an item of data changes, all those cells that are connected to the changed cell by a formlua will also change
   • Accurate calculation
   • Its easy to produce graphs and charts

2. Components of spreadsheets

   • Labels- used for titles, headings, names and identifying rows or columns of data.
   • Data- the values (text or numbers that you enter into the spreadsheet)
   • Formulas- used to perform calculations on the cell content

3. Functions

   • A function is a specialised calculation that the spreadsheet softwarehas memorized
   • Average-