Other slides in this set

Slide 2

Preview of page 2

Here's a taster:

Variables
· Identifier associated with a particular cell, in the cell there's a
value
· Can be a cell reference e.g. D4 or a cell name e.g. VAT_RATE…read more

Slide 3

Preview of page 3

Here's a taster:

Formulas
· Instruction to the computer to process data held in specific
cells
· The way a calculation is represented on a spreadsheet
· Use addresses of cells (cell references or names) and
mathematical operators such as * or /
· Example: A12+(A12*VAT_RATE)…read more

Slide 4

Preview of page 4

Here's a taster:

Functions
· Standard routine built into the computer
· Uses reserved words like SUM
· Used to represent a formula that's to long for a user to enter
in manually
· Examples:
-SUM- add up all range of cells and gives total
-MAX- maximum value in a list
-MIN- minimum value in a list
-LOOKUP- gives a value in a list
-AVERAGE- mean of a range of cells…read more

Slide 5

Preview of page 5

Here's a taster:

Rules
· Set of procedures that must be followed
· E.g. If a calculation needs 2 values then 2 values must be
given
· A validation rule can be added to make sure the value is given
· Also a sequence of events needed for a calculation to work.…read more

Comments

No comments have yet been made

Similar ICT resources:

See all ICT resources »See all resources »