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.