Question: Use an AVERAGEIF function in cells C 2 6 :C 2 7 to find the average GPA of students who passed / failed Exam 1

Use an AVERAGEIF function in cells C26:C27 to find the average GPA of students who passed/failed Exam 1.
Use an AVERAGEIF function again in cells C29:C30 to find the average GPA of students that had an attendance of 90% or higher and the average GPA of students with less than 90% attendance.
Finally, use a COUNTIF function in C32:C33 to find the number of students that passed Exam 1 and the number of students that failed Exam 1.
 Use an AVERAGEIF function in cells C26:C27 to find the average

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 Databases Questions!