Question: b. In cell B15, calculate the difference between cell B11 and B14. C. In the range B18:B21, use the COUNTIF function to count the number

b. In cell B15, calculate the difference between cell B11 and B14. C. In the range B18:B21, use the COUNTIF function to count the number of records of the School field in the Survey table that equal Public, Private, Online, and Tutor. d. In the range B24:B27, use the COUNTIF function to count the number of records in the Prior Conferences field of the Survey table that equal 0, 1, 2, and 3+. e. In cells C14, C15, C18:C21, and C24:C27, divide the counts you calculated for each response group by the total number of responses shown in cell B11 to express the values as percentages (apply appropriate cell referencing)
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
