LIVE Course for free

Rated by 1 million+ students
Get app now
JEE MAIN 2023
JEE MAIN 2023 TEST SERIES
NEET 2023 TEST SERIES
NEET 2023
CLASS 12 FOUNDATION COURSE
CLASS 10 FOUNDATION COURSE
CLASS 9 FOUNDATION COURSE
CLASS 8 FOUNDATION COURSE
0 votes
223 views
in Computer by (117k points)
closed by

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

= EVEN(3) + ODD(8)


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

1 Answer

0 votes
by (59.8k points)
selected by
 
Best answer
Correct Answer - Option 3 : 13

The correct answer is 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
    • All Excel formulas start with an equal (=) sign.
    • 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.

Welcome to Sarthaks eConnect: A unique platform where students can interact with teachers/experts/students to get solutions to their queries. Students (upto class 10+2) preparing for All Government Exams, CBSE Board Exam, ICSE Board Exam, State Board Exam, JEE (Mains+Advance) and NEET can ask questions from any subject and get quick answers by subject teachers/ experts/mentors/students.

Categories

...