Math & Trig =ROUND(number, num_digits)

Quiz =ROUND — 10 Questions

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

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

← ROUND ▦ Practice in Playground

Progress — 10 questions 1 of 10

Question 1 of 10 1/10

Is =ROUND volatile?

Question 2 of 10 2/10

Which function is related to =ROUND?

Question 3 of 10 3/10

Which category does =ROUND belong to?

Question 4 of 10 4/10

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

Question 5 of 10 5/10

Does =ROUND return a dynamic array?

Question 6 of 10 6/10

Which use case fits =ROUND?

Question 7 of 10 7/10

In =ROUND, which is argument #2?

Question 8 of 10 8/10

Is argument “number” required in =ROUND?

Question 9 of 10 9/10

What is the output type of =ROUND?

Question 10 of 10 10/10

Which statement about =ROUND is correct?

Click a question to see the answer.

1. Is =ROUND volatile?

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

Explanation: ROUND is not volatile.

2. Which function is related to =ROUND?

A. IMSEC
B. STDEV.P
C. MROUND ✓
D. CUBESET

Explanation: “MROUND” is related to ROUND.

3. Which category does =ROUND belong to?

A. Text
B. Engineering
C. Database
D. Math & Trig ✓

Explanation: Category is “Math & Trig”.

4. What is the type of argument “number” in =ROUND?

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

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

5. Does =ROUND return a dynamic array?

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

Explanation: ROUND does not spill.

6. Which use case fits =ROUND?

A. Conditional Logic
B. Conditional Aggregation
C. Daily Tasks ✓
D. Descriptive Statistics

Explanation: Use case “Daily Tasks” fits ROUND.

7. In =ROUND, which is argument #2?

A. number
B. criteria
C. lookup_value
D. num_digits ✓

Explanation: Argument #2 is “num_digits”.

8. Is argument “number” required in =ROUND?

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

Explanation: “number” is required.

9. What is the output type of =ROUND?

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

Explanation: Output is “Number”.

10. Which statement about =ROUND is correct?

A. If num_digits is 0, the number is rounded to the nearest integer.
B. To always round up (away from zero), use the ROUNDUP function.
C. Text is always ignored
D. If num_digits is greater than 0 (zero), then number is rounded to the specified number of decimal places. ✓

Explanation: Correct: If num_digits is greater than 0 (zero), then number is rounded to the specified number of decimal places.