9	Using the data in the table, insert a PivotTable in cell A10 on the PivotAnalysis worksheet. Use the following criteria to create the PivotTable: Add the Major and GPA fields to the FILTERS area (in that order). Add the Grade, Year, and FirstName fields to the ROWS area (in that order). Add the Volunteer Hours and LastName fields to the VALUES area (in that order). Display subtotals at the bottom of each group. In cell A10, type Grades. In cell B10, type Total Hours. In cell C10, type Total Students. Resize the columns as needed.
10	Insert a slicer for the Grade field. Format the slicer with 3 columns. Resize the slicer to remove the extra white space at the bottom. Move the slicer so the top-left corner is in cell F10.
11	In the slicer, select A, A-, B+, and B-. View the PivotTable data to determine how many students have a grade of an A or a B. Click cell A2, click the drop-down arrow, and then select the number of students.
12	Clear the filter in the slicer, and then in the slicer select the grade of an A. In cell B8, filter the data so the student with the highest GPA displays. View the PivotTable data to determine which student has the highest GPA. Click cell A4, click the drop-down arrow, and the select the name of the student with the highest GPA displayed.

AutoSave CH H2 Geistweidt 612 grader h2 ShareClub - Read Only Excel Search Geistweidt, Colton GC File Home Insert Draw Page Layout Formulas Data Review View Developer Help Share Comments D38 f =SUM($D$33:$D$37) B C D E H G H 1 K L M N 0 P Q Guilford College Repair and Share Club 1 2 3 3 4 GPA Grade 0.00 F 1.00 D- 1.25 D 1.75 D+ 2.00 C- 2.25 C 2.75 c C+ 3.00 - 3.25 B 3.50 B4 3.90 A A 4.00 A 4.25 A+ Programming 5 Studentin - LastName FirstName Year Major Course - Network Course Course Completed Volunteer Hour GPA Grad 6 30456 Boucher Tom Senior Computer Science Y V Completo 152 3.21 F 7 58965 Garcia Franko Senior Computer Science Y Y Y Complete 182 4.00 8 56792 Glunden Thomas Junior MIS Y N Incomplete 133 1.23 D 9 48795 Blasise Cheryl Sophomore Networking Y Complete 58 3.67 D+ 10 23597 Linde Alice Senior Networking Y Complete 110 3.91 C 11 21486 Benoit Alexia Senior MIS N N Incompleto 140 4.15 C C 12 64687 Cyr Judy Junior Computer Science Y Y Complete 145 2.10 C+ 13 48916 Chu Lini Suphomore Computer Science Y Complete 94 3.50 B- 14 54634 Villani Mark Junior Engineering N N Incomplete 72 1.77 B 15 46846 Zachers John Sophomore Engineering Y Complete 113 1.98 B4 16 41123 Ching Lau Junior MIS N N Incomplete 100 2.40 A 17 18 19 20 Student Report Analysis Headcount 21 Total Total Hours 22 Senior 4 23 Junior 4 24 Sophomore 3 25 "A" Students 26 "D." Students 27 28 29 30 31 Company Donation Information Clubinformation Pivol Analysis (+) Ready lo Display Settings 10046 Type here to search 9 w ? 74F Cloudy 8:01 PM 9/14/2021 AutoSave CH H2 G - Geistweidt 08 grader_h_ShareClub - Read Only Focal Search Geistweidt, Colton GC File Home Insert Draw Page Layout Formulas Data Review View Developer Help Share Comments A10 f 1 K M N O P Q R S 1 u v w B C D E F G H 1 1. Ilow many students have an A or B grade? 2 3 2. Which student has the highest GPA? 4 5 3. Which student logged the most volunteer hours? Which student logged the least? 6 7 B 9 10 11 12 13 14 15 16 17 18 19 21 22 23 24 25 26 27 28 29 30 31 32 33 34 Clubinformalion PivotAnalysis + Ready Display Settings 1009 # Type here to search 9 W ? 74F Cloudy 8:01 PM 9/14/2021 AutoSave CH H2 G - Gcistweidt_608 grader_h2_ShareClub - Read Only - Excel Search Geistweidt, Colton GC File Home Insert Draw Page Layout Formulas Data Review View Developer Help Share Comments D38 > f =SUM($D$33:$D$37) E H G H 1 K L M N 0 P Q B C D 19 20 Student Report Analysis Headcount 21 Total Total Hours 22 Senior 4 23 Junior 4 24 Sophomore 3 - 25 "A" Students 26 "D." Students 27 28 29 30 31 Company Donation Information 32 Company Value Donated Desktops Laptops 33 Safety Inc. S $ 4,600 23 10 13 74 First National S 450 33 22 11 35 Bosco's S 575 25 11 14 36 Software City $ 1,950 17 4 12 37 Sacari Financial 5 1,600 8 2 6 38 $ $ 9,175.00 106 49 157 39 40 41 42 43 44 45 46 47 48 49 50 Status Under Goal Goal Under Goal Under Gual Under Goal Clubinformation PivolAnalysis + Ready lo Display Datings IM 1009 Type here to search 9 W ? 74F Cloudy 8:01 PM 9/14/2021