COMPUTER APPLICATIONS
OFFICE AUTOMATION SOFTWARE
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
To return the remainder after a number is divided by a divisor in EXCEL we use the function?
|
|
ROUND()
|
|
|
FACT()
|
|
|
MOD()
|
|
|
None
|
Explanation:
Detailed explanation-1: -The MOD function syntax has the following arguments: Number Required. The number for which you want to find the remainder. Divisor Required.
Detailed explanation-2: -The MOD function in Excel is used to find remainder after division of one number (dividend) by another (divisor). In mathematics, this operation is called the modulo operation or modulus, hence the name MOD.
Detailed explanation-3: -The Excel MOD function is a built-in function that calculates the remainder after a division operation. This function requires you to reference two numeral inputs in different cells within Excel or enter numbers directly into the function.
There is 1 question to complete.