Spreadsheets are also used a lot for financial and mathematical calculations. The cpts of times can be shown and individual cells can have different values
Variables, Formulae, Rules and Functions are the four main characteristics of spread sheet software
Variables: This is an identifier associated with any particular cell. The variable can be a cell reference e.g. A2 or a cell name e.g. CALCULATE_TOTAL
Formulas: These are a way a spreadsheet can perform calculations. They use numbers, cell references and the mathematical operators +/×÷ e.g. A1 + (A2 × TOTAL)
Rules: A rule is a procedure that must be followed. Validation can be applied to a rule to ensure the calculation is done correctly. For a calculation to work a sequence of events have to take place.
Functions: These are used to present any formula that is too difficult to remember. A function uses preset words that are built into the spreadsheet e.g. SUM, MIN, MAX, AVERAGE AND LOOK UP
Comments
No comments have yet been made