To average the range beginning with B6 and ending with B8, key
A) =B6+B7+B8
B) =B6..B8/3
C) =average(B6:B8)
D) average(B6..B8)

Question

Quizplus · Accepted Answer

The function AVERAGE in Excel is used to calculate the average of a range of cells, which is exactly what is required in this case. Option A simply adds the values, but does not divide by the number of values, giving an incorrect answer. Option B is not a valid Excel function and returns an error. Option D uses the ".." operator which is not recognized in Excel, and also returns an error.

To Average the Range Beginning with B6 and Ending with B8