DATABASE FUNDAMENTALS
ADJUSTING COLUMN WIDTH ROW HEIGHT IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
To round a number to the nearest value based on a specific number or its desired multiple. Is a function of:
|
|
MROUND
|
|
|
CEILING
|
|
|
ROUND
|
|
|
ROUND DOWN
|
|
|
ROUND UP
|
Explanation:
Detailed explanation-1: -MROUND returns a number rounded to the desired multiple.
Detailed explanation-2: -Syntax: MROUND(number, multiple) Number-the value you want to round. Multiple-the multiple to which you want to round the number. For example, the below formula rounds 7 to the nearest multiple of 2 and returns 8 as the result: =MROUND(7, 2)
Detailed explanation-3: -To round a number to a specific multiple (for example, to round to the nearest 0.5), use the MROUND function.
There is 1 question to complete.