Jason wants to average the sales in the range C3:C50, and then round the result to the nearest integer. Which of the following formulas should he use?
A) =ROUND(AVERAGE(C3:C50),0)
B) =AVERAGE((C3:C50), ROUND, 0))
C) =ROUND(C3:C50)
D) AVERAGE(ROUND(C3:C50),0)

Question

Quizplus · Accepted Answer

The formula =ROUND(AVERAGE(C3:C50),0) will first average the sales in the range C3:C50 and then round the result to the nearest integer using the ROUND function. This is the correct approach to achieving Jason's desired result.

B is not a valid formula, as it has syntax errors. 
C will not work as ROUND function requires two arguments.
D is also not correct, as the ROUND function needs to be applied to the result of averaging the sales, not before averaging them.

Jason Wants to Average the Sales in the Range C3:C50