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 GD PYP (Held on 4 Feb 2025 S1)

languageIcon English
  • pdpQsnIcon80 Questions
  • pdpsheetsIcon160 Marks
  • timerIcon60 Mins
languageIcon English
Free
Must Attempt

Hindi Section Test 1

languageIcon English
  • pdpQsnIcon20 Questions
  • pdpsheetsIcon40 Marks
  • timerIcon12 Mins
languageIcon English
Free
Must Attempt

SSC GD Constable Full Mock Test 1

languageIcon English
  • pdpQsnIcon80 Questions
  • pdpsheetsIcon160 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
354k+ students have already unlocked exclusive benefits with Test Prime!
Our Plans
Monthsup-arrow