Spreadsheets have replaced paper-based systems throughout the business world. Although they were first developed for accounting or bookkeeping tasks, they now are used extensively in any context where tabular lists are built, sorted, and shared.
Spreadsheet software is an interactive computer app for the organization, analysis and storage of data in tabular form.
The app operates on data entered in cells of a table.
Do you have spreadsheet software? If not click here to download some free office software from the Apache Software Foundation, who provide software products for the public good. The software is as good as Microsoft equivalents but has less features. Ask for help if you are not sure how to proceed.
the results of formulas that automatically calculate and display a value based on the contents of other cells.
Spreadsheet users can adjust any stored value and observe the effects on calculated values. This makes the spreadsheet useful for "what-if" analysis since many cases can be rapidly investigated without manual recalculation.
In this picture of a spreadsheet the value in the Interest column with a value of £500.00 is cell D2.
The cell with £7,095.34 is E4.
=(B2/100)*C2 is an example of a formula acting on data in cells B2 and C2.