USING MICROSOFT EXCEL
HOW TO ADD COPY AND MOVE WORKSHEETS WITHIN EXCEL WORKBOOKS
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
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?
|
|
=ROUND(AVERAGE(C3:C50), 0)
|
|
|
=AVERAGE((C3:C50), ROUND, 0))
|
|
|
=ROUND(C3:C50)
|
|
|
AVERAGE(ROUND(C3:C50), 0)
|
Explanation:
Detailed explanation-1: -The correct answer is Option (A) =ROUND(AVERAGE(C3:C50), 0) because the AVERAGE function calculates the…
There is 1 question to complete.