There are quick ways to use these everyday functions:

1. Click the cell you wish to display the new value (ie – total)
2. Select the sum button from the toolbar



3. Check the range is correct (for the values you wish to include) If the range is incorrect you can highlight a new range



4. Click OK. The result will appear in the cell you selected (you have to manually type in the words “Total”, “Average” etc to the left of the formula cells)