Spreadsheets

Spreadsheets

1. an electronic document in which data is arranged in the rows and columns of a grid and can be manipulated and used in calculations.

2. Computer models of mathematical data, such as budgets, are usually done using a spreadsheet application

   • or example, a computer model of a school's budget might show that the school will run out of money before the end of the term if it hires an extra teacher.

3. Example of a spreadsheet

4. Note, the =SUM function should only be used when adding a range of cells.

5. Advantages and disadvantages of using spreadsheets

   • Formulae can be used to instantly recalculate totals. For example, if the builder changed his call-out charge, the total cost would be instantly recalculated taking the change into account
   • You can carry out "what if?" investigations. For example, the grocer could increase his prices to see the effect on sales and the builder could increase his hourly charge to see the effect on his daily total.

Images and files in the map