Question

In which function return the remainder after a number is divided by a divisor in EXCEL?

• A. ROUND ( )
• B. FACT ( )
• C. MOD ( )
• D. DIV ( )

Answer 1

Answer:

C. MOD ( )

EXCEL

• The MOD function in Excel returns the remainder of a division operation.
• It takes two arguments : the number and the divisor.
• Example : = MOD ( 17, 5 ) returns 2 , because 17 divided by 5 leaves a remainder of 2.
• So , MOD is the function that specifically returns the remainder.