Instructions On the Class Report worksheet, in cell B7, use the database function to count the number of fees (found in B6) for students who meet the criteria specified in A3:F4 in the database EnrollmentTable. On the Class Report worksheet, in cell B8, use the database function to calculate the average fee (found in B6) for student who meet the criteria specified in A3:F4 in the database EnrollmentTable. On the Class Report worksheet, in cell B9, use the database function to calculate the total fee (found in B6) for students who meet the criteria specified in A3:F4 in the database EnrollmentTable. Format the numbers in cell B8 and B9 as currency with 2 decimal places. Hint: Please make sure to use EnrollmentTable[#All] instead of just EnrollmentTable 12- Calibri (Body) 11 AA General Paste P $ % 9 Format as Table Cell Styles v Calis Edring Analyze Data Sensitivit A4 Student ID BIU xvfx Class Gender Clothes Purchase Fee >30 Column to use for calculations Fee Number of students meeting criteria above Average for students meeting criteria above 3 Sum for students meeting criteria above) 20 31 32 23 34 15 25 17 18 19 20 21 21 23 24 Class 10 25 Class Category 26 Target Class Size 27 Can Spit 28 fee 29 38 " Lookup Table for Fees ZUM23 Total Fee with additional registration charge JAZA Zimba Jarercise YOGZ3 Yoga STPA22 20 20 10 Step Aerobics 30 Y Y N Y SWM39 Swimmercie 10 Y AER39 Aerobics 30 TIQZZ TI CH 20 Y N $50.00 $35.00 540.00 $25.00 $25.00 $30.00 $75.00 Student ID Class ID Gender Clothes Purchase Fee Total Fee with Additional Registration Charge X2396G23 ZUM23 F $25.00 X6260G23 STPA22 M $35.00 X2637G23 STPA22 M X6649G23 YOG23 F $75.00 X3307G23 SWM39 M $15.00 T4742G23 ZUM23 F $25.00 T1011G23 ZUM23 F $25.00 T6528G23 STPA22 M DT2068G23 ZUM23 M $25.00 1X8696G23 AER39 F $35.00 2T9032G23 TJQ22 F BT5701G23 JAZ49 F $25.00 4X6613623 ZUM23 M $25.00 5 TS406G23 AER39 F 6 T5178G23 TJQ22 M $25.00 7X5420G23 SWM39 M $15.00 8 T4814G23 STPA22 F $35.00 9X9593G23 ZUM23 M $76.00 0 T1993G23 AER39 M $60.00 1 T4370G23 TJQ22 F $25.00 2 X3127G23 JAZ49 M $25.00 3 X2204G23 SWM39 F $15.00 4 T4313G23: STPA22 F 5 T3335G231 SWM39 F $15.00 26 T4327G23 ZUM23 F 7 X8027G23 AER39 F $35.00 8 X1934G23 YOG23 F $15.00 29 X5554G23 30 T5210G23 JAZ49 M $25.00 SWM39 M $45.00 31 X5585G23 STPA22 F $35.00 82 X7651623 SWM39 F $15.00 33 T3628G23 ZUM23 M 34 X9847G23 ZUM23 $25.00 A B C D $25.00 34 X9847G23 ZUM23 F 35 T4087G23 JAZ49 F $25.00 36 T4297G23 AER39 M $35.00 37 T2084G23 YOG23 F $15.00 38 X7597G23 YOG23 M 39 T3720G23 YOG23 M $15.00 40 T4413G23 SWM39 F $15.00 41 T3335G23 SWM39 F $68.00 42 T3994G23 TJQ22 F 43 X7892G23 JAZ49 M $25.00 44 X6763G23 JAZ49 M $25.00 45 X7999G23 TJQ22 F $25.00 46 X7095G23 YOG23 F $15.00 47 T1597G23 48 X3372G23 JAZ49 F $25.00 STPA22 M $35.00 49 X9415G23 JAZ49 M $25.00 50 T3671G23 YOG23 F 51 T5995G23 52 T8920G23 SWM39 M $15.00 JAZ49 F $25.00 53 T3712G23 TJQ22 M $80.00 54 X5268G23 STPA22 F $35.00 55 T5124G23 STPA22 M $35.00 56 T4263G23 STPA22 F $35.00 57 T9438G23 YOG23 F $15.00 58 X5630G23 SWM39 F 59 T7209G23 AER39 F $35.00 60 T6558G23 TJQ22 M $25.00 61 X7021G23 AER39 M $35.00 62 T2447G23 TJQ22 F $25.00 63 T1990G23 STPA22 M 64 X4470G23 SWM39 M 65 T5116G23 $15.00 AER39 F 66 T3377G23 $35.00 YOG23 M 67 T7515G23 $15.00 JAZ49 F 68 X8852G23 JAZ49 F $25.00 E 4 > A TOOLS 8 C D TVT 213.00 T7515G23 JAZ49 F X8852G23 JAZ49 F $25.00 T2048G23 JAZ49 F $90.00 OT4894G23 STPA22 F $35.00 T5799G23 ZUM23 M $25.00 2X6421G23 SWM39 F T7814G23 YOG23 M T9540G23 STPA22 M SX3322G23 TJQ22 F $25.00 5X4187G23 STPA22 F $35.00 T9348G23 SWM39 M 3 T3659G23 TJQ22 M $25.00 9X9070G23 SWM39 F $15.00 O X8475G23 ZUM23 M $25.00 X1573G23 SWM39 M 2T1443G23 TJQ22 M $25.00 X2114G23 ZUM23 F $25.00 X9420G23 ZUM23 M $25.00 5X6557G23 TJQ22 F 5 X2280G23 TJQ22 M $25.00 X6273G23 STPA22 F $35.00 BX5727G23 ZUM23 M $25.00 T3358G23 STPA22 M OX3760G23 YOG23 F $15.00 1X6692G23 YOG23 M $15.00 2X8828G23 STPA22 F B X5411G23 SWM39 F $15.00 X6548G23 SWM39 M $15.00 5 5 , B 9