In the Class Report Sheet in B11, enter a function that counts how many students are enrolled. In B12 enter a function that will give you the largest Clothes purchase. In B13 enter a function that averages the fees for all the students. In B14 enter a function that sums all the fees for all the students. Hint: The data is in the Enrollment sheet, but you would use the range names you created. In the Class Report worksheet, in cell B15, enter a function that will count the number of students who are male and taking TJQ22. In B16 enter a function that will sum the clothes purchases for females taking STPA22. Hint: Again, don't forget to use the range names because the data is in the Enrollment sheet. This will be the functions that can handle more than one criteria at a time. Also - Excel will try to interpret the class as if it is a cell address. Be sure to put quotes around it to let Excel know that you are looking for a class, not whatever happens to be in cell TJQ22. (And yes, there is a sell, TJQ22. The spreadsheet is very large.) B Enrollment Analysis Sumn Clothes Enrollment Count per Purchase per Class Type Class Type ZUM23 JAZ49 YOG23 STPA22 SWM39 AER39 9 TJO22 10 11 Count of Student ID: 22 Maximum Clothes Purchase 13 Average fee 14 Total Fees 15 Count Males taking TQ22 15 Sum clothes purchase for Females taking STPA22 17 18 19 21 22 24 Class Class Category 26 Target Class See 27 Can Split Lookup Table for Fees ZUM23 Zumba 20 Y 550.00 JAZAS Farcise 20 Y $35.00 YOG23 Yora 10 N $40.00 STPA22 Step Aerobics 30 Y $25.00 SWM39 Swimmerin 10 Y $25.00 AER 39 Aerobics 30 TI022 Tai Chi 20 N 575.00 $10.00 In the Class Report Sheet in B11, enter a function that counts how many students are enrolled. In B12 enter a function that will give you the largest Clothes purchase. In B13 enter a function that averages the fees for all the students. In B14 enter a function that sums all the fees for all the students. Hint: The data is in the Enrollment sheet, but you would use the range names you created. In the Class Report worksheet, in cell B15, enter a function that will count the number of students who are male and taking TJQ22. In B16 enter a function that will sum the clothes purchases for females taking STPA22. Hint: Again, don't forget to use the range names because the data is in the Enrollment sheet. This will be the functions that can handle more than one criteria at a time. Also - Excel will try to interpret the class as if it is a cell address. Be sure to put quotes around it to let Excel know that you are looking for a class, not whatever happens to be in cell TJQ22. (And yes, there is a sell, TJQ22. The spreadsheet is very large.) B Enrollment Analysis Sumn Clothes Enrollment Count per Purchase per Class Type Class Type ZUM23 JAZ49 YOG23 STPA22 SWM39 AER39 9 TJO22 10 11 Count of Student ID: 22 Maximum Clothes Purchase 13 Average fee 14 Total Fees 15 Count Males taking TQ22 15 Sum clothes purchase for Females taking STPA22 17 18 19 21 22 24 Class Class Category 26 Target Class See 27 Can Split Lookup Table for Fees ZUM23 Zumba 20 Y 550.00 JAZAS Farcise 20 Y $35.00 YOG23 Yora 10 N $40.00 STPA22 Step Aerobics 30 Y $25.00 SWM39 Swimmerin 10 Y $25.00 AER 39 Aerobics 30 TI022 Tai Chi 20 N 575.00 $10.00
