DATABASE FUNDAMENTALS
WORKBOOK THEMES
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
date and time
|
|
|
financial
|
|
|
mathematical
|
|
|
statistical
|
Detailed explanation-1: -The ROUND function rounds a number to a specified number of digits. For example, if cell A1 contains 23.7825, and you want to round that value to two decimal places, you can use the following formula: =ROUND(A1, 2) The result of this function is 23.78.
Detailed explanation-2: -The ROUND Excel function is a built-in function in Excel that calculates the round number of a given number with the number of digits to be provided as an argument. This formula takes two arguments: the number itself and the number of digits to which we want the number to be rounded up.
Detailed explanation-3: -Math.round() The Math.round() static method returns the value of a number rounded to the nearest integer.
Detailed explanation-4: -If num digits is greater than 0, the number is rounded to the specified number of decimal places. For example =ROUND(15.55, 1) rounds 15.55 to 15.6. If num digits is less than 0, all decimal places are removed and the number is rounded to the left of the decimal point (to the nearest ten, hundred, thousand, etc.).