Previous page View a printable version of this page Go back to the contents page for this topic Entering Simple Functions (inc. SUM) Next page
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.

Previous page Page 5 of 8 Next page