Which of the following functions does not contain a syntax error?
A)=AVERAGE(A1:A9)
B)=avg(A1:A9)
C)=AVERAG(A1,A9)
D)=AVERAGE(A1;A9)

Question

Quizplus · Accepted Answer

A is the correct syntax for calculating the average of a range of cells in Excel. B is not in the correct syntax, as Excel does not recognize the "avg" function. C is also not in the correct syntax, as it misspells "average" and separates the cell range with a comma instead of a colon. D also contains a syntax error, as Excel uses a comma to separate arguments, not a semicolon.

Which of the Following Functions Does Not Contain a Syntax