Which MS Excel function is used to round off digits?
Correct answer: Round. The ROUND function rounds a number to a specified number of digits.
Background: The syntax is =ROUND(number, num_digits).
- Trunc: TRUNC cuts off digits without rounding.
- Flop: “Flop” is not an Excel function.
- None of these: “None of these” is incorrect because ROUND is correct.
Did you know? ROUNDUP and ROUNDDOWN force rounding in one direction.
Memory trick: ROUND rounds; TRUNC chops.