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. |
| |
