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

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

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!