Cell A5 contains the number 24.7835.In another cell, Ariane wants to enter the number from cell A5 but rounded to two decimal places.Which of these formulas can she use to do so?
A) =ROUND(A5,2)
B) =MROUND(A5,2)
C) =ROUND(A5,2.0)
D) =MROUND(A5,0.2)

Question

Quizplus · Accepted Answer

The ROUND function is the best choice for rounding a number to a specific number of decimal places. It takes two arguments: the first is the number to be rounded, and the second is the number of decimal places to round to. In this case, Ariane wants to round to two decimal places, so the formula =ROUND(A5,2) will do the trick. MROUND, on the other hand, rounds a number to a specified multiple, which is not what Ariane needs in this case. Option C is incorrect syntax because the second argument of the ROUND function should be an integer, not a decimal. Option D is also incorrect because MROUND requires the second argument to be an integer.

Cell A5 Contains the Number 24