USING MICROSOFT EXCEL
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: -If num digits is greater than 0 (zero), then number is rounded to the specified number of decimal places. 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.
Detailed explanation-3: -For example, to round 2345678 down to 3 significant digits, you use the ROUNDDOWN function with the parameter-4, as follows: = ROUNDDOWN(2345678, -4). This rounds the number down to 2340000, with the “234” portion as the significant digits.
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.