LIVE Course for free

Rated by 1 million+ students
Get app now
Class 8 Foundation Course
Class 9 Foundation Course
Class 10 Foundation Course
Class 11 Foundation Course
Class 12 Foundation Course
JEE COURSE
NEET COURSE
0 votes
43 views
in General by (54.3k points)
closed by
What will be the result of the following MS-Excel formula?
=ODD(20)+EVEN(39)
1. 57
2. 50
3. 61
4. 59

1 Answer

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

The correct answer is 61.

  • The ODD function rounds a positive number up to the nearest odd integer. 
  • The EVEN function rounds a positive number up to the nearest even integer.
  • ODD(20) equals 21.
  • EVEN(39) equals 40.
  • Hence, the Sum is 61.

  • The ISEVEN function returns TRUE if a number is even and FALSE if a number is odd.
  • The ISODD function returns TRUE if a number is odd and FALSE if a number is even. 

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

...