Entering Simple Functions (inc. SUM)
Formulas can become very long if you want to include a lot of numbers in the calculation. They often take a long time to type and it is easy to make mistakes in them.


Functions can be used in some formulas to make them simpler. For example, you can use =SUM to add up lots cells quickly


You can Type Different Functions into Cell B51 to Calculate other Answers:

Function Explanation
=MIN(B2:B50) This will find the smallest score in the range of cells B2 to B50.
=MAX(B2:B50) This will find the largest score in the range of cells B2 to B50.
=AVERAGE(B2:B50) This will find the average score in the range of cells B2 to B20.

Made by Mr S Haughton