hamburger menu
All Coursesall course arrow
adda247
reward-icon
adda247
    arrow
    arrow
    arrow
    What will be the result of the following MS Excel formula? =EVEN(3) + ODD(8)
    Question

    What will be the result of the following MS Excel formula?
    =EVEN(3) + ODD(8)

    A.

    9

    B.

    14

    C.

    13

    D.

    11

    Correct option is C

    In MS Excel, the EVEN and ODD functions return the nearest even or odd number, respectively, to the number provided as an argument.
    · EVEN(3): This function rounds the number 3 up to the nearest even number, which is 4.
    · ODD(8): This function rounds the number 8 up to the nearest odd number, which is 9.
    So the formula =EVEN(3) + ODD(8) calculates as:
    · 4 + 9 = 13
    Important Key Points:
    1. EVEN Function: Rounds a number up to the nearest even integer.
    2. ODD Function: Rounds a number up to the nearest odd integer.
    Knowledge Booster:
    · EVEN(3): Even numbers are multiples of 2, so 3 is rounded up to 4 (the nearest even number).
    · ODD(8): Odd numbers are numbers that are not divisible by 2 without a remainder, so 8 is rounded up to 9 (the nearest odd number).

    Free Tests

    Free
    Must Attempt

    SSC CGL T-I Similar Paper (Held on 12 Sep 2025 S2)

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

    SSC CGL T-I GA Section Test 01

    languageIcon English
    • pdpQsnIcon25 Questions
    • pdpsheetsIcon50 Marks
    • timerIcon15 Mins
    languageIcon English
    Free
    Must Attempt

    SSC CGL T-I Full Mock Test 1 (Exam Level)

    languageIcon English
    • pdpQsnIcon100 Questions
    • pdpsheetsIcon200 Marks
    • timerIcon60 Mins
    languageIcon English
    test-prime-package

    Access ‘Delhi Police Constable’ Mock Tests with

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