Olympics Part 2

1. Open the the file that you saved for Olympic Part 1 (you saved it as Olympics Part 1).

2. Save the file as Olympic Part 2.

3. Change the font to Courier 12 point.

4. Filter the WINNINGS column to show dollar amounts less than or equal to $20,000. Filtering help

5. Sort the spreadsheet by WINNINGS in descending order. Sorting help

6. Center the column headings (RANK, FIRST, LAST, COUNTRY and WINNINGS). How to center text

7. Type AVERAGE WINNINGS in cell C40. Use uppercase and bold letters.

8. Use a function to calculate the average winnings. Insert the function in cell F40. How to use the average function.

9. Print TWO copies of your spreadsheet.
COPY 1-show row and column headings, gridlines and print in landscape format.
how to print gridlines
how to print row and column headings
COPY 2-show row and column headings and show formulas (press the CTRL key and ~key). Print in landscape format using the fit to one page option.

10. Now the chart- create a Clustered column with a 3-D visual effect that shows last names and winnings only. Create the chart on a separate sheet using these guidelines:
-the title should be: USA Triathlete Winnings (your name here).
-label the X axis with the word Triathletes.