Math & Trig =MOD(number, divisor)

Quiz =MOD — 15 Questions

15 quiz questions about =MOD — test syntax, arguments, examples & errors!

Questions: 10 questions 15 questions Random 10 or 15 questions from the pool + shuffled options each time

← MOD ▦ Practice in Playground

Progress — 15 questions 1 of 15

Question 1 of 15 1/15

Is =MOD volatile?

Question 2 of 15 2/15

What is the output type of =MOD?

Question 3 of 15 3/15

Which is the correct syntax of =MOD?

Question 4 of 15 4/15

Which formula is a valid example of =MOD?

Question 5 of 15 5/15

How many arguments does =MOD have in total?

Question 6 of 15 6/15

In =MOD, which is argument #2?

Question 7 of 15 7/15

How many optional arguments does =MOD have?

Question 8 of 15 8/15

Which function is related to =MOD?

Question 9 of 15 9/15

What usually causes #DIV/0! in =MOD?

Question 10 of 15 10/15

What is the fix for #DIV/0! in =MOD?

Question 11 of 15 11/15

How many required arguments does =MOD have?

Question 12 of 15 12/15

What is the type of argument “number” in =MOD?

Question 13 of 15 13/15

Which use case fits =MOD?

Question 14 of 15 14/15

Is argument “number” required in =MOD?

Question 15 of 15 15/15

Does =MOD return a dynamic array?

Click a question to see the answer.

1. Is =MOD volatile?

A. Yes
B. No
C. —
D. No ✓

Explanation: MOD is not volatile.

2. What is the output type of =MOD?

A. Date
B. Logical
C. Number ✓
D. Array

Explanation: Output is “Number”.

3. Which is the correct syntax of =MOD?

A. =INT(number, divisor)
B. =MOD(number, divisor) ✓
C. =MOD(number, divisor, 0)
D. MOD(number, divisor)

Explanation: Correct syntax: =MOD(number, divisor)

4. Which formula is a valid example of =MOD?

A. MOD(3, 2)
B. =MOD(3, 2) ✓
C. =INT(3, 2)
D. =MOD(3, 2, 0)

Explanation: Correct example: =MOD(3, 2)

5. How many arguments does =MOD have in total?

A. 4
B. 1
C. 2 ✓
D. 3

Explanation: =MOD has 2 required, 0 optional (2 total).

6. In =MOD, which is argument #2?

A. divisor ✓
B. range
C. value
D. number

Explanation: Argument #2 is “divisor”.

7. How many optional arguments does =MOD have?

A. 0 ✓
B. —
C. 1
D. 2

Explanation: =MOD has 2 required, 0 optional (2 total).

8. Which function is related to =MOD?

A. INT ✓
B. COUPPCD
C. COUNT
D. DELTA

Explanation: “INT” is related to MOD.

9. What usually causes #DIV/0! in =MOD?

A. Text is always ignored
B. Output is always a dynamic array
C. Requires add-in
D. If divisor is 0, MOD returns the #DIV/0! error value. ✓

Explanation: If divisor is 0, MOD returns the #DIV/0! error value. — Fix: Check the divisor

10. What is the fix for #DIV/0! in =MOD?

A. Text is always ignored
B. Only works in old versions
C. Output is always a dynamic array
D. Check the divisor ✓

Explanation: If divisor is 0, MOD returns the #DIV/0! error value. — Fix: Check the divisor

11. How many required arguments does =MOD have?

A. 3
B. 4
C. 2 ✓
D. 1

Explanation: =MOD has 2 required, 0 optional (2 total).

12. What is the type of argument “number” in =MOD?

A. Number ✓
B. Reference
C. Value
D. Array

Explanation: Type of “number” is “Number”.

13. Which use case fits =MOD?

A. Text Manipulation
B. External Data, Web & Cube
C. Numbering & Sample Data
D. Conditional Formatting & Validation ✓

Explanation: Use case “Conditional Formatting & Validation” fits MOD.

14. Is argument “number” required in =MOD?

A. —
B. Yes
C. Yes ✓
D. No

Explanation: “number” is required.

15. Does =MOD return a dynamic array?

A. Yes
B. No
C. —
D. No ✓

Explanation: MOD does not spill.