Which of the following is not a valid formula in Microsoft Excel?
A
AVG(A1:A6)
B
AVERAGE(A1:A6)
C
MEDIAN(A1:A6)
D
MEDIAN(2,4,4,5)
Correct Option:
A
Explanation
The formula =AVG(A1:A6) is invalid because Excel's function is AVERAGE, not AVG. Option C has been corrected to =MEDIAN(A1:A6), which is valid, as are options B and D. Therefore, A is the only invalid formula.
