Functions are built-in formulae which can perform more complex calculations. They can save you a lot of time. Our spreadsheet contains a typical shopping list.
Calculating the Total
We could add up the values individually, but that would take too long. The SUM function will add all values in a range.
- Click E3
- Type =SUM(
- Click C2 and, keeping your mouse button clicked, move down to C15. This should select all of the prices.
- Type ) to end the function.
- Press enter to complete.
Calculating the Average
We can find the average from a range by using the AVERAGE function. Use this in the same way as the SUM function.
- Click E6
- Type =AVERAGE(
- Click C2 and, keeping your mouse button clicked, move down to C15. This should select all of the prices.
- Type ) to end the function.
- Press enter to complete.
Finding the Minimum and Maximum Values
The MIN and MAX functions return the lowest and highest values from a range. Using the same sequences as the SUM and AVERAGE functions, show the cheapest price in E9 and the highest price in E12.