DATABASE FUNDAMENTALS
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 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-2: -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.
Detailed explanation-3: -To stop numbers from being displayed as rounded, you can increase the number of decimal places for that number, or you can increase the column width. Note: By default, Excel displays two decimal places when you apply the number, currency, accounting, percentage, or scientific format to cells or data.