Fichas
Chapter 4
Fichas del conjunto (4)
- 1Formulae- Use numbers, references/names (addresses) of cells & mathematical operators
- MATHEMATICAL OPERATORS - e.g. +, -, /, *
E.g. =A12+(A12*VAT) - 2Functions- Used to represent formula that is too complex or too long for an ordinary user to enter
-Uses reserved words built into spreadsheet (MIN, MAX, SUM, COUNTIF) - 3Variables- Value contained in cell used when variable is used
- Identifier associated with a particular cell
- Could be cell reference (e.g. D4) or cell name (e.g. VAT) - 4Rules- Validation rules applied to ensure values are given
- Sequence of events required for calculation to work
Información
- Descripción
- (Chapter 4) ICT Fichas sobre Chapter 4, creado por rolfs003 el 16/04/2013.
- Creado por
- rolfs003
- Visitas
- 50
- Etiquetas
- Valoración