The data in the Student Test Data worksheet has a couple of problems to fix:

The data should be organized alphabetically by student.

Format the data so the school faculty can use slicers to filter data. Use any style you want.

Display slicers so data can be filtered by month, by subject, or by student or by any combination of the three. Go ahead and display the slicers, but you don$$t need to apply any filtering.

Find and delete the duplicate records. There should be $90$ unique records.

The data should include a Total row to calculate the average score.

The PivotTable on the Student Pivot sheet should summarize the average scores for each subject for each student by month. However, the Score field data have been added to the wrong section of the PivotTable.

Move the Score field to the correct section of the PivotTable.

Modify the calculation to display the average score instead of the total score.

The PivotChart on the Faculty Pivot sheet should show the size of each department as a proportional part of a whole. A line chart was the wrong choice.

Change the chart type to a better choice.

Display Data Labels using the Data Callout

The school finance committee has determined that a $$30,000$ facilities upgrade will be needed in five years. An alumnus has donated $$22,000.$ If invested, will it grow to be enough? That depends on the rate of return. On the Data Table worksheet, an attempt has been made to use Excel$$s data table feature to determine the value of the investment after five years at different rates of return. The formula in cell D$6$ is correct, but something went wrong with the data table. Delete the zeros in cells D$7$:D$30$ and try again. Even if you$$re not familiar with the FV formula used in cell D$6,$ you should be able to figure this out.

Save and close the workbook.

Upload and save your project file.

Submit project for grading.