Spreadsheet software

Spreadsheet software

1. Benefits

   • You can perform what if investigations
   • Automatic recalculation
   • Accurate calculation
   • Easy to produce graphs and charts

2. components

   • Labels
     • used for titles, headings, names and for identifying rows or columns of data
   • Data
     • the values that you enter into the spreadsheet
   • Formulas
     • are used to perform calculations on the cell contents

3. Functions

   • a function is a specialised calculation that the spreadsheet software has memorised.
   • average - to find out the average of the numbers in a range of cells
   • sum - displays the total of all cells from cells E3 to P3

4. formatting data