Insert Draw Page Layout Formulas Data Review View Tell me Calibri (Body) 11 ' = 29 Wrap Text General A Merge & Center $ % ) Condit Format D G Guilford College Repair and Share Club Programming Course Network Cour Lame 30456 boucher SMS Garcia 56792 Conden A735 Blue 21557 Linde 21436 5468 CH 45 h 54564 Vilni Firsthame Tom Frank Thomas Cheryl Alice Nes Judy un Y Y N Y Year Maler Senior Computer Science Senior Computer Science Junior MIS Sophomore Networking Senior Networking Senior MIS Junior Computer Science Sophomore Computer Science TULE Engineering Sophomore Epineering Iunie Course Complete Volunteer Hou GPA Grad Complete 152 3.21 Complete 182 0.00 0 Incomplete 1.23 0 Complete 58 367 0 Complete 110 1.91 incomplete 149 615 C Complete 145 2.10 Co Complete 94 3.50 Incomplete 72 1778 Complete 113 1.988 Incomplete 109 > 40 A N N Y N John Y N Y N 12 Y N 13 Student Report Ana He Tart Tours Status Com Donation information Dope Lotus 4.500 10 13 4501 23 13 SP2 13 14 1 4 11 1. 5 1 5 14 3 Apply Pivot Style Medium 9 to the Pivot Table. Apply Slicer Style Dark 1 to the slicer. Sort the PivotTable by Grades A to Z. Note, depending upon the version Office being used, the Pivot style name may be Light Blue, Pivot Style Medium 9. The slicer style name may be Light Blue, Slicer Style Dark 1. 15 7 Insert a Clustered Column PivotChart on a new worksheet named PivotChartAnalysis. Remove the Total Students field from the VALUES area. Delete the legend. In the chart title, replace Total with Volunteer Hours by Student. Apply Style 4 to the PivotChart. Ensure that the worksheets are correctly named and placed in the following order in the workbook: Clubinformation, PivotChartAnalysis, PivotAnalysis. Save the workbook, exit Excel, and then submit your file as directed by your instructor. 16 0