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

Question

Quizplus · Accepted Answer

Option D contains a correct syntax for calculating the average of the values in cells B1 through B9. Option A also has correct syntax, but option B has a misspelling of the AVERAGE function and option C uses a semicolon instead of a comma as the separator between the cell references.

Which of the Following Functions Does Not Contain a Syntax