Question

What is the ouput of the following functions:
a) =Mod(10, 4)
b) =Min(3, 4, -5, -6)
c) =Len("New Book")
d) =Product(10, 5, 2)
e) =Sum(20, 3, 5)
f) =Max(45, 56, 102, 8)
g) =Count(23, 4, 6)​

Answer 1

Answer:

What is the MOD Function?

The MOD function is categorized under Excel Math and Trigonometry functions. The function helps find a remainder after a number (dividend) is divided by another number (divisor).

As a financial analyst, the function is useful when we need to process every nth value. For example, if our data comprises several columns of numbers, we can use MOD to sum every nth column.

Formula

=MOD(number,divisor)

This function uses the following arguments:

Number (required argument) – This is the number for which we wish to find the remainder.

Divisor (required argument) – This is the number by which we want to divide the number.