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

How many optional arguments does =CEILING.PRECISE have?

Question 3 of 10 3/10

Does =CEILING.PRECISE return a dynamic array?

Question 4 of 10 4/10

Which use case fits =CEILING.PRECISE?

Question 5 of 10 5/10

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

Question 6 of 10 6/10

What is the output type of =CEILING.PRECISE?

Question 7 of 10 7/10

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

Question 8 of 10 8/10

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

Question 9 of 10 9/10

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

Question 10 of 10 10/10

Which statement about =CEILING.PRECISE is correct?

Click a question to see the answer.

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

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

Explanation: Version: “Excel 2013”.

2. How many optional arguments does =CEILING.PRECISE have?

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

Explanation: =CEILING.PRECISE has 1 required, 1 optional (2 total).

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

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

Explanation: CEILING.PRECISE does not spill.

4. Which use case fits =CEILING.PRECISE?

A. Forecasting & Trends
B. Scientific & Unit Conversion
C. Numbering & Sample Data
D. Rounding & Numeric ✓

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

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

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

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

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

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

Explanation: Output is “Number”.

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

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

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

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

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

Explanation: Argument #2 is “significance”.

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

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

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

10. Which statement about =CEILING.PRECISE is correct?

A. Requires add-in
B. Text is always ignored
C. Volatile and recalculates every time
D. The absolute value of the multiple is used, so that the CEILING.PRECISE function returns the mathematical ceiling irrespective of the signs of number and significance. ✓

Explanation: Correct: The absolute value of the multiple is used, so that the CEILING.PRECISE function returns the mathematical ceiling irrespective of the signs of number and significance.