The Excel function to remove decimal or fractional part of the number is:

Correct option is C

• The TRUNC function in Excel removes the decimal or fractional part of a number without rounding.
• It simply cuts off the decimal portion.
• Correct answer word – TRUNC
Meaning: removes decimal part without rounding
Example: TRUNC(5.89) = 5
Information Booster:
• Syntax: TRUNC(number, [num_digits])
• Useful when exact integer values are required.
Additional Knowledge:
• REPLACE (Option A) – replaces text
• ABS (Option B) – returns absolute value
• AVG (Option D) – not a valid Excel function (correct is AVERAGE)