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

223 views
in Computer
closed

What will be the result of the following MS Excel formula?

= EVEN(3) + ODD(8)

1. 9
2. 14
3. 13
4. 11

by (59.8k points)
selected by

Correct Answer - Option 3 : 13

•  The answer of the formula = EVEN(3) + ODD(8) in excel is 13.

• The EVEN function rounds a positive number up to the nearest even integer i.e. 3 will become 4.
• The ODD function rounds a positive number up to the nearest odd integer i.e. 8 will become 9.
• Hence, 9+4= 13.
• A function is a predefined formula that performs calculations using specific values in a particular order.
• How to Write Formulas in Excel
• The answer to the formula is displayed in the cell into which the formula is entered.
• Cells are referenced in a formula by their column-row identifier.
• The symbols for addition, subtraction, multiplication, and division are: + - * /
• We do not have to enter capital letters in the formula, They will be capitalized automatically.