Calculate the Grand Total

Next you will use a built-in function to quickly calculate the SUM of all purchases:

1. Click once in Column C on the last item in your list (quantity column).
2. Press the DOWN ARROW 2 times
3. Type Grand Total and then press the RIGHT ARROW to move into the blank cell next to it in Column D
4. Click once on the FUNCTIONS BUTTON on the toolbar
5. Choose SUM
6. Click and drag over all data in Column D
7. Press ENTER
8. The total amount of money spent is displayed in the active cell.

NEXT

Go Back