Page 317 - Microsoft Word - 00 ACCA F2 Prelims.docx

Spreadsheets

Uses of spreadsheets

A spreadsheet is a computer package that is used to manipulate data. Much of the
data of a company is likely to be held on spreadsheets. Spreadsheets can be used
for anything with a rows and columns format. One of the most useful functions of a
spreadsheet is being able to input formulae to enable calculation to happen
automatically when data is input in specific cells.

Spreadsheets are a convenient way of setting up all sorts of charts, records and
tables. Uses include:

 'what if?' analysis

 budgeting and forecasting

 reporting performance

 variance analysis

 inventory valuation.

311