What is the value of the following MS-Excel formula?
=MOD(11, 3)

Correct option is D

The MOD function in MS Excel returns the remainder when one number is divided by another. In the formula =MOD(11, 3), 11 is divided by 3, and the remainder of that division is 2.
· 11 ÷ 3 equals 3 with a remainder of 2. Therefore, the MOD function will return 2.
Important Key Points:
1. MOD Function: The MOD function is used to find the remainder of division between two numbers. The syntax is MOD(number, divisor).
2. Remainder: The result of the MOD function is the remainder, not the quotient of the division.
Knowledge Booster:
· Quotient vs. Remainder: While division gives a quotient (whole number result) and a remainder, the MOD function specifically gives you the remainder part of the division.