3.AutoSum is a function in Microsoft Excel and other spreadsheet programs that automatically enters the appropriate formula or function into your spreadsheet. 1.ROUND is the major rounding function in Excel that rounds a numeric value to a specified number of digits.
Syntax: ROUND(number, num_digits)
Number - any real number you want to round. This can be a number, reference to a cell containing the number or a formula-driven value.
Num_digits - the number of digits to round the number to. You can supply a positive or negative value in this argument:
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.).For example =ROUND(15.55, -1) rounds 15.55 to the nearest 10 and returns 20 as the result.
If num_digits equals 0, the number is rounded to the nearest integer (no decimal places).
For example =ROUND(15.55, 0) rounds 5.55 to 16.
The Excel ROUND function follows the general math rules for rounding, where the number to the right of the rounding digit determines whether the number is rounded upwards or downwards. Rounding digit is the last significant digit retained once the number is rounded, and it gets changed depending on whether the digit that follows it is greater or less than 5:
If the digit to the right of the rounding digit is 0, 1, 2, 3, or 4, the rounding digit is not changed, and the number is said to be rounded down.
If the rounding digit is followed by 5, 6, 7, 8, or 9, the rounding digit is increased by one, and the number is rounded up.
2. about. approximately. around. I would go with "about" because it has a lot of verbal coverage.
