Asked by Joyce Beddingfield on Jun 03, 2024
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.
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.
Learning Objectives
- Comprehend the application of fundamental Excel functions and formulas such as IF, DATE, YEAR.
Related questions
To Show Formulas Instead of Values, Click on the Formulas ...
Jason Wants to Display the Text Poor If the Value ...
Excel's ____________________ Function,which Adds All of the Numbers in a ...
You Can Press the CTRL+ACCENT MARK(`)keys to Display the Formulas ...
You Can Click the Logical Button (FORMULAS Tab | Function ...