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



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

 

A.

REPLACE


B.

 ABS 


C.

 TRUNC  


D.

 AVG

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)

Free Tests

Free
Must Attempt

OSSC CGL 2024 Prelims PYP (Held on 20-Oct-2024)

languageIcon English
  • pdpQsnIcon150 Questions
  • pdpsheetsIcon150 Marks
  • timerIcon150 Mins
languageIcon English
Free
Must Attempt

Odisha GK Test 01

languageIcon English
  • pdpQsnIcon10 Questions
  • pdpsheetsIcon10 Marks
  • timerIcon10 Mins
languageIcon English
Free
Must Attempt

OSSC CGL Prelims Full Mock Test 01

languageIcon English
  • pdpQsnIcon150 Questions
  • pdpsheetsIcon150 Marks
  • timerIcon150 Mins
languageIcon English
test-prime-package

Access ‘OSSSC Excise Constable, Forester, FG’ Mock Tests with

  • 60000+ Mocks and Previous Year Papers
  • Unlimited Re-Attempts
  • Personalised Report Card
  • 500% Refund on Final Selection
  • Largest Community
students-icon
387k+ students have already unlocked exclusive benefits with Test Prime!
Our Plans
Monthsup-arrow