Buying Need someone to create a Microsoft Excel spreadsheet

I need this spreadsheet made. If you can do this (should be quite easy) please PM me your price.

Instructions:

SPREADSHEET TEST
You are to use Microsoft Excel to modify an existing spreadsheet that shows alumni donations for a school. You must use formulas and/or functions to perform the calculations. Text in quotes should be entered without the quotation marks. Follow the instructions below exactly and do not make any additional formatting changes. Proofread your work carefully. ​

1. Open the Microsoft Excel data file from the location specified by the instructor.
2. Hide columns B through F, columns K, M, N, O, and columns R through AA.
3. Insert two blank rows at the top of the spreadsheet.
4. In cell A1 enter your name and the date.
5. Delete column H.
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 “AVERAGE DOLLARS”.
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 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 the top.
12. In the “EXPECTED VS. ACTUAL” column, create a formula that calculates the difference between the expected and actual
donations (“EXPECTED DONATIONS” minus “ACTUAL DONATIONS”). Calculate this value for all the classes .
13. Format the numbers in the “AVERAGE DOLLARS” column as currency with 2 decimal places and right justified.
14. Enter the row title “AVERAGE” in cell A29 (right justify using bold and uppercase letters).
15. In row 29, use the AVERAGE function to calculate the average amounts for the “EXPECTED DONATIONS”, “ACTUAL DONATIONS”, and “EXPECTED VS. ACTUAL” columns.
16. Format the averages as numbers with 1 decimal place (right justify using bold numbers).
17. Sort the spreadsheet data by “CLASS YEAR” in descending order.
18. Filter the spreadsheet so that it shows only the rows with ALUMNIgreater than 200.
19. Change all the 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 the data showing, but without changing the font size or type. Make sure the scaling is set to
100%. Do NOT use the Fit to 1 page feature.
21.Print the filtered spreadsheet, in landscape orientation, on one page, showing all formulas, gridlines, and row and column
headings . 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. Do NOT include the averages in the chart. Make sure the class officer names appear on the X-axis.

• The legend should show “EXPECTED DONATIONS” and “ACTUAL DONATIONS”.
• Title the chart “Alumni 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.

 

hi....i can do it...pm me
thanks

 

I found someone. Thanks.

THREAD CLOSED