solve

3. The data in the Student Test Data worksheet has a couple of problems to fix: a. The data should be organized alphabetically by student. b. Format the data so the school faculty can use slicers to filter data. Use any style you want. c 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. d. Find and delete the duplicate records. There should be 90 unique records. a. The data should include a Total row to calculate the average score. 4, 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. a. Move the Score field to the correct section of the PivotTable. b, Modify the calculation to display the average score instead of the total score. 5. 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. aL] Change the chart type to a better choice