To return the remainder after a number is divided by a divisor in EXCEL we use the function? A. ROUND ( ) B. FACT ( ) C. MOD ( ) D. DIV ( )

ROUND ( )
FACT ( )
MOD ( )
DIV ( )

The correct answer is C. MOD ( ).

The MOD function returns the remainder after a number is divided by a divisor. For example, if you have the number 12 and the divisor 3, the MOD function will return 0, because 12 divided by 3 is 4 with a remainder of 0.

The other functions are not used to return the remainder after a number is divided by a divisor. The ROUND function rounds a number to a specified number of decimal places. The FACT function returns the factorial of a number. The DIV function divides two numbers and returns the quotient.

Here is an example of how to use the MOD function in Excel:

=MOD(12,3)

This will return the value 0, because 12 divided by 3 is 4 with a remainder of 0.

Exit mobile version