Math & Trig =MROUND(number, multiple)

Quiz =MROUND — 10 Questions

10 quiz questions about =MROUND — test syntax, arguments, examples & errors!

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

← MROUND ▦ Practice in Playground

Progress — 10 questions 1 of 10

Question 1 of 10 1/10

What is the fix for #NUM! in =MROUND?

Question 2 of 10 2/10

Does =MROUND return a dynamic array?

Question 3 of 10 3/10

Is =MROUND volatile?

Question 4 of 10 4/10

Which statement about =MROUND is correct?

Question 5 of 10 5/10

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

Question 6 of 10 6/10

Which formula is a valid example of =MROUND?

Question 7 of 10 7/10

What is the output type of =MROUND?

Question 8 of 10 8/10

What usually causes #NUM! in =MROUND?

Question 9 of 10 9/10

How many required arguments does =MROUND have?

Question 10 of 10 10/10

Is argument “multiple” required in =MROUND?

Click a question to see the answer.

1. What is the fix for #NUM! in =MROUND?

A. Make the two arguments the same sign ✓
B. Select entire column for best performance
C. Output is always a dynamic array
D. Requires add-in

Explanation: If not, a #NUM error is returned. — Fix: Make the two arguments the same sign

2. Does =MROUND return a dynamic array?

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

Explanation: MROUND does not spill.

3. Is =MROUND volatile?

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

Explanation: MROUND is not volatile.

4. Which statement about =MROUND is correct?

A. Requires add-in
B. Only works in old versions
C. MROUND rounds up, away from zero, if the remainder of dividing number by multiple is greater than or equal to half the value of multiple. ✓
D. Volatile and recalculates every time

Explanation: Correct: MROUND rounds up, away from zero, if the remainder of dividing number by multiple is greater than or equal to half the value of multiple.

5. What is the type of argument “number” in =MROUND?

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

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

6. Which formula is a valid example of =MROUND?

A. =MROUND(10, 3, 0)
B. =CEILING-MATH(10, 3)
C. MROUND(10, 3)
D. =MROUND(10, 3) ✓

Explanation: Correct example: =MROUND(10, 3)

7. What is the output type of =MROUND?

A. Mixed
B. Reference
C. Number ✓
D. Date

Explanation: Output is “Number”.

8. What usually causes #NUM! in =MROUND?

A. Output is always a dynamic array
B. Volatile and recalculates every time
C. Text is always ignored
D. If not, a #NUM error is returned. ✓

Explanation: If not, a #NUM error is returned. — Fix: Make the two arguments the same sign

9. How many required arguments does =MROUND have?

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

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

10. Is argument “multiple” required in =MROUND?

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

Explanation: “multiple” is required.