Steps to complete this project:
Mark the steps as checked when you complete them.
Open the start file EX2019-FixIt-5-6. The file will be renamed automatically to include your name. Change the project file name if directed to do so by your instructor, and save it.
If the workbook opens in Protected View, click the Enable Editing button in the Message Bar at the top of the workbook so you can modify the workbook.
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 12 years. An alumnus has donated $24,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 12 years at different rates of return. The formula in cell D6 is correct, but something went wrong with the data table. Delete the zeros in cells D7:D30 and try again. Even if you’re not familiar with the FV formula used in cell D6, you should be able to figure this out.
Steps to complete this project: Mark the steps as checked when you complete them
By admin