1. Copy the "exceldata.xls" file from the M drive, _student folder, Intro to Computers folder to your I drive. Don't open your completed Excel Practice Exam 1- copy the file from the M drive to your I drive.

2. Hide columns B through E and columns G,L,M and N.

3. Insert two blank rows at the top of the spreadsheet.

4. In cell A1 enter your name and the date.

5. Delete column J.

6. Starting in row 2, column A, enter the following column titles (using bold and uppercase letters) in this order from left to right: “CLASS OFFICER”, “ALUMNI”, “EXPECTED DONATIONS”, “ACTUAL DONATIONS”, “CLASS YEAR”, “CLASS FRIENDS” and “INTEREST RATE”.

7. Between the “ACTUAL DONATIONS” and “CLASS YEAR” columns, insert a column labeled “EXPECTED VS. ACTUAL” (using bold and uppercase letters).

8. For the column titles (row 2), turn on the wrap text feature.

9. Make the columns wide enough so that each column title has no more than two words per line. Make sure no words are split between two lines. Make sure all of the data in the remaining cells is fully visible.

10. Set the horizontal alignment of each column title to the center.

11. Set the vertical alignment of each column title to top.

12. In the “EXPECTED VS. ACTUAL” column, create a formula that calculates the difference between the expected donations and actual donations (“EXPECTED DONATIONS” minus “ACTUAL DONATIONS”). Calculate this value for all the classes.

13. Format the numbers in the “INTEREST RATE” column as currency with 2 decimal places and right justified.

14. Filter the spreadsheet so that it shows ALUMNI greater than 200.

15. Sort the spreadsheet by “CLASS YEAR” in descending order.

16. Enter the row title “AVERAGE” in cell A29 (right justify using bold and uppercase letters).

17. In row 29, use the AVERAGE function to calculate the average amount for the “EXPECTED DONATIONS”, “ACTUAL DONATIONS”, and “EXPECTED VS. ACTUAL” columns.

18. Format each average as Number with 1 decimal place (right justify using bold numbers).

19. Change all cells to Arial font, size 10.

20. Print the filtered spreadsheet in landscape orientation showing gridlines and row and column headings. Make the spreadsheet fit on one page with all data showing, but without changing font size or type. Keep the scaling at 100%. Do NOT use the Fit to 1 page feature.

21. Print the filtered spreadsheet, in landscape orientation, on one page, showing all formulas, showing gridlines. Use the Fit to 1 page feature. Ignore the resulting format changes.

22. Create a clustered column chart that uses the following data: “CLASS OFFICER”, “EXPECTED DONATIONS” and “ACTUAL DONATIONS” on the filtered spreadsheet. Make sure that the class officer names appear on the X-axis.
> Legend should show “ACTUAL DONATIONS” and “EXPECTED DONATIONS”.
> Title the chart “DONATIONS” and include YOUR NAME as part of the title.
> Label the X-axis of the chart “CLASS OFFICERS”.
> Label the Y-axis of the chart “DOLLARS IN THOUSANDS”.
> Create the chart as a new sheet.
> Change the font of the class officer names on the chart to Arial font, size 8.

23. Print the column chart in landscape orientation.

Your completed exam should contain:
1. printed spreadsheet.
2. printed spreadsheet showing formulas.
3. printed column chart.