need explanation

8. Use the Student Records worksheet to create a pivot table shown below on a new worksheet. Rename the worksheet Tuition Pivot Table. Name the pivot table Tuition_PT. Ensure you add a row between when formatting the table. Move this sheet after the Program Materials Cost Sheet. Your final Pivot Table will not look like this after filtering in Question 10. (5 marks) E B D 1 Program Paid 2019/2020 2 Total Material 3 Years Total Tuition Costs Total Paid 4 2019 $ 71,000 $ 10,975 $ 49,960 5 6 2020 $ 54,000 $ 8,600 $ 37,108 7 8 Grand Total $ 125,000 $ 19,575 $ 87,068 Number Owing 27 20 47 9. From the Tuition PivotTable worksheet, create a PivotChart. Use a pie chart that shows the Tuition totals for 2019 and 2020. Name the chart title Tuition, keep the legend, add labels using Best fit showing values and percentages, and move it to the Dashboard worksheet. Place it between the range 17:026. (3 marks) 10. Create two slicers from the Tuition Pivot Table worksheet. The first slicer should display Program. Place between D24:H34 on the Dashboard worksheet. Filter for English, German, and Hindi. (2 marks) TO D - OA 15 W 969 fort NAI VOICE MORE COMMUNICATION COLLEGE Student Payment Records 3 4512 EST Cho DETS DO 1 51 S 6000 333050 NOW 17 Pula Wedel 2-04-19 43-19 Heroker Droh English 5-12- 6-20 P Hoone Sposa . Star 10-15 nen French 11-2012 Hid som >>20-30 Le Praha Chlor Fresh 6-5-20 Min 2930 Spanish 12 A 1-1-19 Low Erol 2018 oranoto Ergin H-18 Era 11-30 9-30 Student Records Aragan Maut Don OR TOOL $ 3.000 1 000 13700.00 59. 525000 5 1.000.00 5 2.300 39000 300 Linden 120100 14 20 320000 525000 Caband Price Type here to search O 1 300000 -AA 1 4 Engle 3 2000 000 English Sari 3 Coman Hogan Chinese Bere 3 French 20 Bonde German Franch 1 Search 2020 More 5 4 2010 She you Spanish Kumar French Norong Erol 21 4 . . Engla Student Records Program Materials Cost Dashboard Documentation ORIGINAL TOOL Type here to search o Century Both R14 DE F N 2 3 VOICE MORE COMMUNICATION COLLEGE 4 6 7 Engish German Hindi 9 10 11 12 13 14 15 16 17 Tullion Tuition Tuition Balance Balance Balance 19 20 21 Dashboard Student Records Program Materials Cost Documentation ORGNAL TOOL PERE i Type here to search 8. Use the Student Records worksheet to create a pivot table shown below on a new worksheet. Rename the worksheet Tuition Pivot Table. Name the pivot table Tuition_PT. Ensure you add a row between when formatting the table. Move this sheet after the Program Materials Cost Sheet. Your final Pivot Table will not look like this after filtering in Question 10. (5 marks) E B D 1 Program Paid 2019/2020 2 Total Material 3 Years Total Tuition Costs Total Paid 4 2019 $ 71,000 $ 10,975 $ 49,960 5 6 2020 $ 54,000 $ 8,600 $ 37,108 7 8 Grand Total $ 125,000 $ 19,575 $ 87,068 Number Owing 27 20 47 9. From the Tuition PivotTable worksheet, create a PivotChart. Use a pie chart that shows the Tuition totals for 2019 and 2020. Name the chart title Tuition, keep the legend, add labels using Best fit showing values and percentages, and move it to the Dashboard worksheet. Place it between the range 17:026. (3 marks) 10. Create two slicers from the Tuition Pivot Table worksheet. The first slicer should display Program. Place between D24:H34 on the Dashboard worksheet. Filter for English, German, and Hindi. (2 marks) TO D - OA 15 W 969 fort NAI VOICE MORE COMMUNICATION COLLEGE Student Payment Records 3 4512 EST Cho DETS DO 1 51 S 6000 333050 NOW 17 Pula Wedel 2-04-19 43-19 Heroker Droh English 5-12- 6-20 P Hoone Sposa . Star 10-15 nen French 11-2012 Hid som >>20-30 Le Praha Chlor Fresh 6-5-20 Min 2930 Spanish 12 A 1-1-19 Low Erol 2018 oranoto Ergin H-18 Era 11-30 9-30 Student Records Aragan Maut Don OR TOOL $ 3.000 1 000 13700.00 59. 525000 5 1.000.00 5 2.300 39000 300 Linden 120100 14 20 320000 525000 Caband Price Type here to search O 1 300000 -AA 1 4 Engle 3 2000 000 English Sari 3 Coman Hogan Chinese Bere 3 French 20 Bonde German Franch 1 Search 2020 More 5 4 2010 She you Spanish Kumar French Norong Erol 21 4 . . Engla Student Records Program Materials Cost Dashboard Documentation ORIGINAL TOOL Type here to search o Century Both R14 DE F N 2 3 VOICE MORE COMMUNICATION COLLEGE 4 6 7 Engish German Hindi 9 10 11 12 13 14 15 16 17 Tullion Tuition Tuition Balance Balance Balance 19 20 21 Dashboard Student Records Program Materials Cost Documentation ORGNAL TOOL PERE i Type here to search