In Excel, the formula ____ will calculate the average of the values in cells B14 through F14.
A) =AVERAGE
B) =AVERAGE[B14:F14]
C) =AVERAGE{B14:F14}
D) =AVERAGE(B14:F14)

Question

Quizplus · Accepted Answer

The correct syntax for calculating the average of values within a range in Excel is to use the AVERAGE function, followed by the range of cells in parentheses. Option D is the only answer that uses this correct syntax, so it is the best choice.

In Excel, the Formula ____ Will Calculate the Average of the Values