Discussion
In MS Excel, the ROUND function with the arguments =ROUND(3.14159,2) returns
Answer: D
Correct answer: 3.14
=ROUND(3.14159,2) rounds to two decimal places, giving 3.14. The second argument is the number of decimal places. That argument may be zero, which rounds to a whole number, or negative, which rounds to the left of the decimal point: =ROUND(1234,-2) gives 1200. That is a detail worth knowing, since it is the neat way to round to the nearest hundred or thousand. The related functions differ in direction. ROUNDUP and ROUNDDOWN always go the same way regardless of the digit; MROUND rounds to the nearest multiple; INT truncates towards negative infinity; and TRUNC simply cuts the decimals off. The important practical point is that ROUND changes the stored value, whereas decreasing the decimal places displayed only changes the appearance. A column that appears to total wrongly is almost always displaying rounded figures while summing the full ones.
Post your comment
Please log in or register to post a comment.
Examination Categories
- SSC Exams
- Banking Exams
- Teaching Exams
- Civil Services Exams
- Railways Exams
- Engineering Recruitment Exams
- Defence Exams
- State Government Exams
- Police Exams
- Insurance Exams
- Nursing Exams
- Other Government Exams
- NRA CET
- PG Entrance Exams
- Campus Placement
- MBA Entrance Exams
- CUET and UG Entrance
- Judiciary Exams
- Regulatory Body Exams
- Software Development