Asked by Joyce Beddingfield on Jun 03, 2024

verifed

Verified

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)

ROUND

A mathematical function used to round a number to a specified number of digits, often used in spreadsheet applications.

  • Comprehend the application of fundamental Excel functions and formulas such as IF, DATE, YEAR.
verifed

Verified Answer

MA
Maryama AbdulkadirJun 06, 2024
Final Answer :
A
Explanation :
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.