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

Data Analysis & Interpretation Subject Test 01

languageIcon English
  • pdpQsnIcon20 Questions
  • pdpsheetsIcon20 Marks
  • timerIcon30 Mins
languageIcon English
Free
Must Attempt

Logical Capability Subject Test 01

languageIcon English
  • pdpQsnIcon20 Questions
  • pdpsheetsIcon20 Marks
  • timerIcon25 Mins
languageIcon English
Free
Must Attempt

RRB Station Master Full Mock Test 1

languageIcon English
  • pdpQsnIcon100 Questions
  • pdpsheetsIcon100 Marks
  • timerIcon120 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
564k+ students have already unlocked exclusive benefits with Test Prime!
Our Plans
Monthsup-arrow