DATABASE FUNDAMENTALS
MODIFYING PAGE SETUP PROPERTIES IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
Round a number to a given number of digits
|
|
|
take the decimal part of the number
|
|
|
get the integer part of the number
|
|
|
round number to 2 decimal places
|
Detailed explanation-1: -What is the ROUND Function? The ROUND Function[1] is categorized under Excel Math and Trigonometry functions. The function will round up a number to a specified number of digits. Unlike the ROUNDUP and ROUNDDOWN functions, the ROUND function can round either up or down.
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: -ROUNDDOWN : The ROUNDDOWN function rounds a number to a certain number of decimal places, always rounding down to the next valid increment. MROUND : Rounds one number to the nearest integer multiple of another.
Detailed explanation-4: -The ROUND() function rounds a number to a specified number of decimal places.
Detailed explanation-5: -Rounding is a process to estimate a particular number in a context. To round a number look at the next digit in the right place, if the digit is less than 5, round down and if the digit is 5 or more than 5, round up.