DATABASE FUNDAMENTALS
HOW TO INSERT DELETE COLUMNS ROWS IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
SUM
|
|
|
AVERAGE
|
|
|
ROUND
|
|
|
MAX
|
Detailed explanation-1: -If num digits is 0, the number is rounded to the nearest integer. If num digits is less than 0, the number is rounded to the left of the decimal point. To always round up (away from zero), use the ROUNDUP function. To always round down (toward zero), use the ROUNDDOWN function.
Detailed explanation-2: -Click in an empty cell. On the Formulas tab, under Function, click Formula Builder. In number, type the number you are rounding up. In num digits, type 0 to round the number up to the nearest whole number.
Detailed explanation-3: -Round, RoundDown, and RoundUp RoundDown always rounds down to the previous lower number, towards zero. RoundUp always rounds up to the next higher number, away from zero.
Detailed explanation-4: -The round() function returns a floating point number that is a rounded version of the specified number, with the specified number of decimals. The default number of decimals is 0, meaning that the function will return the nearest integer.
Detailed explanation-5: -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.