LIVE Course for free

Rated by 1 million+ students
Get app now
0 votes
in Computer by (53.1k points)
closed by

What is the value of the following MS-Excel formula?  

=MOD(11, 3) 

1. 3 
2. 4
3. 5
4. 2

1 Answer

0 votes
by (54.5k points)
selected by
Best answer
Correct Answer - Option 4 : 2

The correct answer is 2.

  • MOD function gives the remainder when a number is divided by a divisor.

  • In mathematics, this operation is known as the modulo operation or modulus, Here it is known as MOD.
  • The symbol is %.For example, MOD (10, 3) = 1.
  • The result of MOD carries the same sign as it is categorized in maths.
  • It can be used in an Excel sheet.
  • As a worksheet function, the MOD function can also be entered as part of the formula in a cell of a worksheet.
  • It is the absolute value (or modulus) |x| of a real number x namely, |x| = x for a positive x, |x| = − x for a negative x, and |0|.

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.