Math & Trig =CEILING.PRECISE(number, [significance])

Quiz =CEILING.PRECISE — 10 Questions

10 quiz questions about =CEILING.PRECISE — test syntax, arguments, examples & errors!

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

← CEILING.PRECISE ▦ Practice in Playground

Progress — 10 questions 1 of 10

Question 1 of 10 1/10

Since which Excel version is =CEILING.PRECISE available?

Question 2 of 10 2/10

Which is the correct syntax of =CEILING.PRECISE?

Question 3 of 10 3/10

Which formula is a valid example of =CEILING.PRECISE?

Question 4 of 10 4/10

Which function is related to =CEILING.PRECISE?

Question 5 of 10 5/10

Does =CEILING.PRECISE return a dynamic array?

Question 6 of 10 6/10

Which use case fits =CEILING.PRECISE?

Question 7 of 10 7/10

What is the type of argument “number” in =CEILING.PRECISE?

Question 8 of 10 8/10

What is the output type of =CEILING.PRECISE?

Question 9 of 10 9/10

Is argument “significance” required in =CEILING.PRECISE?

Question 10 of 10 10/10

In =CEILING.PRECISE, which is argument #2?

Click a question to see the answer.

1. Since which Excel version is =CEILING.PRECISE available?

A. Excel 2013 ✓
B. Excel 2019
C. All versions
D. Excel 365

Explanation: Version: “Excel 2013”.

2. Which is the correct syntax of =CEILING.PRECISE?

A. =ABS(number, [significance])
B. =CEILING.PRECISE(number, [significance]) ✓
C. =CEILING.PRECISE(number, [significance], 0)
D. CEILING.PRECISE(number, [significance])

Explanation: Correct syntax: =CEILING.PRECISE(number, [significance])

3. Which formula is a valid example of =CEILING.PRECISE?

A. =ABS(4.3)
B. =CEILING.PRECISE(4.3) ✓
C. =CEILING.PRECISE(4.3, 0)
D. CEILING.PRECISE(4.3)

Explanation: Correct example: =CEILING.PRECISE(4.3)

4. Which function is related to =CEILING.PRECISE?

A. ABS ✓
B. RIGHTB
C. SORT
D. ROUND

Explanation: “ABS” is related to CEILING.PRECISE.

5. Does =CEILING.PRECISE return a dynamic array?

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

Explanation: CEILING.PRECISE does not spill.

6. Which use case fits =CEILING.PRECISE?

A. Sort, Filter & Dedupe
B. Conditional Logic
C. Rounding & Numeric ✓
D. Depreciation

Explanation: Use case “Rounding & Numeric” fits CEILING.PRECISE.

7. What is the type of argument “number” in =CEILING.PRECISE?

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

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

8. What is the output type of =CEILING.PRECISE?

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

Explanation: Output is “Number”.

9. Is argument “significance” required in =CEILING.PRECISE?

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

Explanation: “significance” is optional.

10. In =CEILING.PRECISE, which is argument #2?

A. range
B. number
C. significance ✓
D. criteria

Explanation: Argument #2 is “significance”.