Math & Trig =MROUND(number, multiple)

Quiz =MROUND — 15 Questions

15 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 — 15 questions 1 of 15

Question 1 of 15 1/15

Which function is NOT related to =MROUND?

Question 2 of 15 2/15

How many optional arguments does =MROUND have?

Question 3 of 15 3/15

In =MROUND, which is argument #1?

Question 4 of 15 4/15

How many arguments does =MROUND have in total?

Question 5 of 15 5/15

In =MROUND, which is argument #2?

Question 6 of 15 6/15

Which statement about =MROUND is correct?

Question 7 of 15 7/15

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

Question 8 of 15 8/15

Since which Excel version is =MROUND available?

Question 9 of 15 9/15

Which category does =MROUND belong to?

Question 10 of 15 10/15

Is argument “multiple” required in =MROUND?

Question 11 of 15 11/15

Which is the correct syntax of =MROUND?

Question 12 of 15 12/15

Which function is related to =MROUND?

Question 13 of 15 13/15

Is argument “number” required in =MROUND?

Question 14 of 15 14/15

How many required arguments does =MROUND have?

Question 15 of 15 15/15

What is the output type of =MROUND?

Click a question to see the answer.

1. Which function is NOT related to =MROUND?

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

Explanation: “LOGNORMDIST” is not related to MROUND.

2. How many optional arguments does =MROUND have?

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

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

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

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

Explanation: Argument #1 is “number”.

4. How many arguments does =MROUND have in total?

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

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

5. In =MROUND, which is argument #2?

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

Explanation: Argument #2 is “multiple”.

6. 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. Only works in old versions
D. Requires add-in

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.

7. What is the type of argument “multiple” in =MROUND?

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

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

8. Since which Excel version is =MROUND available?

A. Excel 365
B. Excel 2019
C. Excel 2007 (Compatibility)
D. All versions ✓

Explanation: Version: “All versions”.

9. Which category does =MROUND belong to?

A. Lookup & Reference
B. Information
C. Math & Trig ✓
D. Financial

Explanation: Category is “Math & Trig”.

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

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

Explanation: “multiple” is required.

11. Which is the correct syntax of =MROUND?

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

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

12. Which function is related to =MROUND?

A. CEILING-MATH ✓
B. CHISQ.INV
C. CONFIDENCE
D. EXP

Explanation: “CEILING-MATH” is related to MROUND.

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

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

Explanation: “number” is required.

14. How many required arguments does =MROUND have?

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

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

15. What is the output type of =MROUND?

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

Explanation: Output is “Number”.