Home  Back Topics CD Orders  INDEX 
Spreadsheets
A spreadsheet stores data in cells and performs and displays calculations on the data.

Spreadsheets may consist of a number of different (but related) sheets

If data is changed then automatic re-calculation of formulae occurs.

Microsoft Excel is an example of a spreadsheet package.
Spreadsheets allow the user to ....
  • add and edit data in cells
  • import data from files or other applications
  • format the data in cells (fonts, colours...etc)
  • format the type of data (dates, currency, decimal places...etc)
  • enter mathematical formulae or pre-defined functions (eg average, sum, maximum, count) into cells
  • sort data
  • produce graphs from the data

 
Spreadsheets can be used for modelling real-life situations or for 'what if?' investigations. They are often used for setting budgets for businesses.