6 7 In cells B22:B24, using named ranges, create functions that count the number of students if their year in school matches the years listed in A22:A24. In cells C22:C24, using named ranges, create functions that total the number of volunteer hours if their year in school matches the years listed in A22:A24. In cells C25:C26, using named ranges, create functions that total the number of volunteer hours if the criteria n A26:A27 is met. In cell A38, type Totals. Create a formula in cells B38:E38 to find the total sum for the Value, Donated, Desktops, and Laptops columns respectively. 4 6 8 In cell F33, create an IF function that evaluates the total number of computers donated from Safety Inc. If a minimum of 30 computers have been donated, the function will return Goal Met. If fewer than 30 computers are donated, the function will return Under Goal. Use AutoFill to copy the function to cell range F34:F37. 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. Save OFF De03 grader_h2_ShareClub Schneider Julian-Saved to my Mac Insert Draw Page Layout Formulas Data Review View Tell me Calibri (Body) 11 AA == Wrap Text General BIU Merge & Center $ % 9 +898 Conditional Form Formatting as Ta X fx D G Guilford College Repair and Share Club Stude LastName FirstName Year Major Programming Course Network Cours Course Complet Volunteer Hou GPA 30456 Boucher 58965 Gara Tom Senior Computer Science Complete 152 Franko Senior Computer Science Complete 182 Grad 3.21 F 4.00 D- 56792 Glonden Thomas Junior MIS N Incomplete 133 1.23 D 48795 Basise Cheryl Sophomore Networking Y Complete 58 3.67 D- 23597 Linde Alice Senior Networking Y Y Complete 110 3.91 C 21486 Benoit Alexis Senior MIS N N Incomplete 149 4.15 C 64687 Cy Judy Junior Computer Science Y Y Complete 145 2.10 C+ 48546 Chu Lin Sophomore Computer Science Y Y Complete 94 3.50 - 54684 Villani Mark Junior Engineering N N Incomplete) 22 1.77 B 46546 Zachris John 41173 Ching Lau Sophomore Engineering Junio Y Complete 113 1.988+ MIS N N Incomplete 109 2.40 A 25 Student Report Analysis Headcount Total Total Hours Company Donation information Value Donated Desktops Laptops Status 4.600 23 10 13 $ 450 22 11 S 375 35 11 14 $ 1350 17 A 2 $ 1.400 3 PestAnalysis