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

Quiz =CEILING.PRECISE — 15 Questions

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

Question 1 of 15 1/15

How many required arguments does =CEILING.PRECISE have?

Question 2 of 15 2/15

Which is the correct syntax of =CEILING.PRECISE?

Question 3 of 15 3/15

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

Question 4 of 15 4/15

Which statement about =CEILING.PRECISE is correct?

Question 5 of 15 5/15

How many optional arguments does =CEILING.PRECISE have?

Question 6 of 15 6/15

Which use case fits =CEILING.PRECISE?

Question 7 of 15 7/15

Which category does =CEILING.PRECISE belong to?

Question 8 of 15 8/15

Since which Excel version is =CEILING.PRECISE available?

Question 9 of 15 9/15

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

Question 10 of 15 10/15

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

Question 11 of 15 11/15

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

Question 12 of 15 12/15

Does =CEILING.PRECISE return a dynamic array?

Question 13 of 15 13/15

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

Question 14 of 15 14/15

Which function is NOT related to =CEILING.PRECISE?

Question 15 of 15 15/15

How many arguments does =CEILING.PRECISE have in total?

Click a question to see the answer.

1. How many required arguments does =CEILING.PRECISE have?

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

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

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

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

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

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

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

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

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

A. 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. ✓
B. Output is always a dynamic array
C. Volatile and recalculates every time
D. Text is always ignored

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.

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

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

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

6. Which use case fits =CEILING.PRECISE?

A. Reshape Tables
B. External Data, Web & Cube
C. Conditional Formatting & Validation
D. Rounding & Numeric ✓

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

7. Which category does =CEILING.PRECISE belong to?

A. Information
B. Compatibility
C. Text
D. Math & Trig ✓

Explanation: Category is “Math & Trig”.

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

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

Explanation: Version: “Excel 2013”.

9. In =CEILING.PRECISE, which is argument #1?

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

Explanation: Argument #1 is “number”.

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

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

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

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

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

Explanation: Argument #2 is “significance”.

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

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

Explanation: CEILING.PRECISE does not spill.

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

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

Explanation: “significance” is optional.

14. Which function is NOT related to =CEILING.PRECISE?

A. AREAS ✓
B. ABS
C. ARABIC
D. AGGREGATE

Explanation: “AREAS” is not related to CEILING.PRECISE.

15. How many arguments does =CEILING.PRECISE have in total?

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

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