Mrs. Novotny uses Excel to track her students' grades. The first students' quiz scores are stored in Row 2, Columns B through E. Which of the following is a multimath formula which represents the average of the students' quiz scores?
A) =SUM(B2:E2)
B) =(B2+E2)/5
C) =SUM(B2:E2)/5
D) =B2+C2+D2+E2/5

Question

Quizplus · Accepted Answer

The function =SUM(B2:E2)/5 will add up the quiz scores in cells B2 through E2, and then divide the sum by 5 to get the average. This is the appropriate formula for calculating the average of a set of numbers.

Mrs Novotny Uses Excel to Track Her Students' Grades