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

Which function is NOT related to =MROUND?

Question 2 of 10 2/10

Is =MROUND volatile?

Question 3 of 10 3/10

Which statement about =MROUND is correct?

Question 4 of 10 4/10

How many optional arguments does =MROUND have?

Question 5 of 10 5/10

Does =MROUND return a dynamic array?

Question 6 of 10 6/10

Which is the correct syntax of =MROUND?

Question 7 of 10 7/10

In =MROUND, which is argument #1?

Question 8 of 10 8/10

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

Question 9 of 10 9/10

Is argument “number” required in =MROUND?

Question 10 of 10 10/10

How many required arguments does =MROUND have?

Click a question to see the answer.

1. Which function is NOT related to =MROUND?

A. CEILING-MATH
B. FLOOR-MATH
C. INT
D. TRIM ✓

Explanation: “TRIM” is not related to MROUND.

2. Is =MROUND volatile?

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

Explanation: MROUND is not volatile.

3. Which statement about =MROUND is correct?

A. Output is always a dynamic array
B. 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. ✓
C. Requires add-in
D. Text is always ignored

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.

4. How many optional arguments does =MROUND have?

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

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

5. Does =MROUND return a dynamic array?

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

Explanation: MROUND does not spill.

6. Which is the correct syntax of =MROUND?

A. =MROUND(number, multiple, 0)
B. =MROUND(number, multiple) ✓
C. =CEILING-MATH(number, multiple)
D. MROUND(number, multiple)

Explanation: Correct syntax: =MROUND(number, multiple)

7. In =MROUND, which is argument #1?

A. lookup_value
B. number ✓
C. multiple
D. range

Explanation: Argument #1 is “number”.

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

A. Logical
B. Mixed
C. Number ✓
D. Value

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

9. Is argument “number” required in =MROUND?

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

Explanation: “number” is required.

10. How many required arguments does =MROUND have?

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

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