Cumulative Exam

Question 34 of 50 • CHS- TX-Professional Communications (CR)

A teacher uses the spreadsheet below to determine the average quiz score of each student. The teacher inserts this information into column E. In column F, which function can be cut and pasted into different cells to tell the teacher if each student exceeded the satisfactory average?

Answer

=IF(E3>E8, “Exceeded”)

=IF(E3>$E$8, "Exceeded")

=IF(AVERAGE(E3:E6)>E8, “Exceeded”)

=IF(AVERAGE(E3:E6)>$E$8, “Exceeded”)

Cumulative Exam

Marketing, Sales, and Service Education and Qualifications

Marketing, Sales, and Service Career Pathways