Shopping Spree Part 2

Open the the Excel spreadsheet that you completed in Part 1 of the Shopping Spree Assignment.

1. Skip one row below your last line of data and enter the word TOTAL (BOLD and UPPERCASE) in column A.

2. Enter the word AVERAGE (BOLD and UPPERCASE) below the word TOTAL in column A.

3. Using the AutoSum button , calculate the total of your purchases and enter this sum in column C on the same row as the word TOTAL.

4. Using the Average formula enter the average price of your purchases in column C on the same row as the word TOTAL.

Your spreadsheet should look like this:

5. Change the font of your spreadsheet to Comic Sans 16.

6. Adjust the column widths so that no words or numbers are cutoff and are readable.

7. Print the spreadsheet in portrait orientation showing gridlines and row and column headings.

8. Now show formulas (hold down the control key and press the ~ key) and print your spreadsheet again in portrait orientation. Use the "fit to one page" option when printing.