354822
Description
Variables, formulae, functions and rules
- Variable: holds value
which can change.
- You can name variables such as 'VAT'
- It is clear to see what it is doing.
- A range of cells can also be given a
single variable name.
- It is clear to see what it is doing.
- You can name variables such as 'VAT'
- Pros and cons of using
named variables
- Pros
- Makes formulas easier to
understand
- A named variable can also reference a
cell in another worksheet without the
formula looking any different
- Simple to move a variable to another location
without any formulas being changed
- Makes formulas easier to
understand
- Cons
- Can be confusing if you use the
same name in different worksheets
- Pick sensible names -
some may be unhelpful
- Can be confusing if you use the
same name in different worksheets
- Pros
- Rules: a set of procedures that must be followed in
order to get the right answer. Can also be a sequence
of events required for the calculation to work.
- Formulae: performs calculations using numbers,
addresses of cells and mathematical operators.
- Formulas contains functions.
- Careful of mistakes i.e. using a named cell that no
longer exists or deleting cells that are being used.
- Formulas contains functions.
- Functions: Standard routine used to perform
common tasks.It represents a complex formula that
uses reserved words such as VLOOKUP and IF.
- Performs a specific set of operations on its
input values to produce a single output value.
- Performs a specific set of operations on its
input values to produce a single output value.
- Differences between formulae
and functions
- Formula
- Typed directly into the formula bar
- Simple calculations
- Simple calculations
- Unable to nest a formula
- Do not have built-in wizards
- Typed directly into the formula bar
- Functions
- Built into the software,
special type of formula
- Can nest functions
- Simplify complicated maths
- Built-in wizard e.g.
VLOOKUP
- Built into the software,
special type of formula
- Formula
Media attachments
0 comments
Want to create your own Mind Maps for free with GoConqr? Learn more.