DATABASE FUNDAMENTALS
BASICS OF BIG DATA
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
ROUNDIF
|
|
|
ROUND
|
|
|
ROUNDDOWN
|
|
|
ROUNDUP
|
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: -Excel ROUND function ROUND is the major rounding function in Excel that rounds a numeric value to a specified number of digits.
Detailed explanation-3: -ROUNDUP behaves like ROUND, except that it always rounds a number up. If num digits is greater than 0 (zero), then number is rounded up to the specified number of decimal places. If num digits is 0, then number is rounded up to the nearest integer.
Detailed explanation-4: -For this demand, you can text =ROUND(SUM(Number1, Number2, …), 0) in the input box of the cell that you want to sum. Then press enter, the sum of the cell is rounded. For example, I choose A6 as my sum cell. After text the ROUND function in the input box, the result came out correctly.
Detailed explanation-5: -For example, the formula “=ROUND(123.456, -2)” results in a value of 100 while “=ROUND(123.456, 2)” results in a value of 123.46. If you want to consistently round up, substitute ROUND for the ROUNDUP function. To always round down, use the ROUNDDOWN function instead.