7.1 Reviewing spreadsheets

A spreadsheet is an application that is used to organise and manipulate data. A spreadsheet is divided into columns and rows, enabling data to be organised in a systematic manner.

The columns and rows create cells that are used to store data and formula.

TS0701

A spreadsheet can be used to:

  • list, sort and filter data
  • make calculations with functions
  • link data from one sheet or file to another.

While all these tasks can be performed by hand on paper, it is much quicker to use a computerised spreadsheet because the formulae are automatically recalculated each time new data is entered or changed.