hamburger menu
All Coursesall course arrow
adda247
reward-icon
adda247
    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

    SBI Clerk Prelims Full Mock Test-01

    languageIcon English
    • pdpQsnIcon100 Questions
    • pdpsheetsIcon100 Marks
    • timerIcon60 Mins
    languageIcon English
    Free
    Must Attempt

    SBI Clerk Prelims 2026 : Reasoning Section Test 01

    languageIcon English
    • pdpQsnIcon35 Questions
    • pdpsheetsIcon35 Marks
    • timerIcon20 Mins
    languageIcon English
    Free
    Must Attempt

    SBI Clerk Prelims 2026 : Quantitative Aptitude Section Test 01

    languageIcon English
    • pdpQsnIcon35 Questions
    • pdpsheetsIcon35 Marks
    • timerIcon20 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
    496k+ students have already unlocked exclusive benefits with Test Prime!
    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
    496k+ students have already unlocked exclusive benefits with Test Prime!
    Our Plans
    Monthsup-arrow