Define Range

Cell References

Use $ to fix row or column.

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

Advance Excel Training