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 use case fits =MROUND?

Question 2 of 10 2/10

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

Question 3 of 10 3/10

Is argument “number” required in =MROUND?

Question 4 of 10 4/10

Which function is related to =MROUND?

Question 5 of 10 5/10

Which statement about =MROUND is correct?

Question 6 of 10 6/10

Which is the correct syntax of =MROUND?

Question 7 of 10 7/10

Is =MROUND volatile?

Question 8 of 10 8/10

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

Question 9 of 10 9/10

Which category does =MROUND belong to?

Question 10 of 10 10/10

In =MROUND, which is argument #2?

Click a question to see the answer.

1. Which use case fits =MROUND?

A. Descriptive Statistics
B. Loans & Installments
C. Daily Tasks
D. Rounding & Numeric ✓

Explanation: Use case “Rounding & Numeric” fits MROUND.

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

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

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

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

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

Explanation: “number” is required.

4. Which function is related to =MROUND?

A. TRIMMEAN
B. MMULT
C. CEILING-MATH ✓
D. ARABIC

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

5. Which statement about =MROUND is correct?

A. 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. ✓
B. Requires add-in
C. Text is always ignored
D. Select entire column for best performance

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.

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. Is =MROUND volatile?

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

Explanation: MROUND is not volatile.

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

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

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

9. Which category does =MROUND belong to?

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

Explanation: Category is “Math & Trig”.

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

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

Explanation: Argument #2 is “multiple”.