USING MICROSOFT EXCEL
USING THE UPPER AND LOWER FUNCTIONS IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
RAND
|
|
|
ROUND
|
|
|
RADIANS
|
|
|
ROMAN
|
Detailed explanation-1: -To avoid the floating-point rounding issue in a precise calculation like currency, Java has introduced a BigDecimal class. We can use BigDecimal instead of float or double. Arithmetic, comparison, hashing, rounding, manipulation, and format conversion are all supported by this class.
Detailed explanation-2: -To always round up (away from zero), use the ROUNDUP function. To always round down (toward zero), use the ROUNDDOWN function. To round a number to a specific multiple (for example, to round to the nearest 0.5), use the MROUND function.
Detailed explanation-3: -Rounding errors can occur when a formula result is too large or too small to be accurately represented as a number with a certain number of decimal places. For example, if a formula result is 4.12345 and you format the cell to display only two decimal places, the displayed value will be 4.12.