7. Differences between formulae and functions

FORMULA	FUNCTION
A formula is typed directly into the formula bar	A function is built into the software.; it is a special type of formula
Unable to nest a formula	Can nest functions
Formula are simple calculations	Functions are used to simplify complicated maths
Formulas do not have built-in wizards	A function often has a built-in wizard to help you complete them e.g. VLOOKUP

challenge see if you can find out one extra fact on this topic that we haven't already told you