Correct option is C
• In Microsoft Excel, the TRUNC function removes the decimal (fractional) part of a number.
• Example:
TRUNC(12.89) = 12
Information Booster:
• Syntax: TRUNC(number, [num_digits])
Additional Knowledge:
• ABS → gives absolute value
• REPLACE → replaces text
• AVG → not a valid function (correct is AVERAGE)