Math & Trig =CEILING(number, significance)

Quiz =CEILING — 10 Questions

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

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

← CEILING ▦ Practice in Playground

Progress — 10 questions 1 of 10

Question 1 of 10 1/10

In =CEILING, which is argument #1?

Question 2 of 10 2/10

What is the output type of =CEILING?

Question 3 of 10 3/10

Which function is related to =CEILING?

Question 4 of 10 4/10

How many arguments does =CEILING have in total?

Question 5 of 10 5/10

What is the fix for #VALUE! in =CEILING?

Question 6 of 10 6/10

Which use case fits =CEILING?

Question 7 of 10 7/10

Does =CEILING return a dynamic array?

Question 8 of 10 8/10

In =CEILING, which is argument #2?

Question 9 of 10 9/10

Which statement about =CEILING is correct?

Question 10 of 10 10/10

What usually causes #VALUE! in =CEILING?

Click a question to see the answer.

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

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

Explanation: Argument #1 is “number”.

2. What is the output type of =CEILING?

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

Explanation: Output is “Number”.

3. Which function is related to =CEILING?

A. FLOOR ✓
B. DSTDEV
C. IMSIN
D. MAXIFS

Explanation: “FLOOR” is related to CEILING.

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

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

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

5. What is the fix for #VALUE! in =CEILING?

A. Output is always a dynamic array
B. Only works in old versions
C. Select entire column for best performance
D. برای هر دو آرگومان مقدار عددی وارد کنید. ✓

Explanation: If either argument is nonnumeric, CEILING returns the #VALUE! error value. — Fix: برای هر دو آرگومان مقدار عددی وارد کنید.

6. Which use case fits =CEILING?

A. Data Cleaning
B. Loans & Installments
C. Rounding & Numeric ✓
D. Lookup & Retrieval

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

7. Does =CEILING return a dynamic array?

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

Explanation: CEILING does not spill.

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

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

Explanation: Argument #2 is “significance”.

9. Which statement about =CEILING is correct?

A. Requires add-in
B. If number is negative, and significance is positive, the value is rounded up towards zero.
C. Regardless of the sign of number, a value is rounded up when adjusted away from zero. If number is an exact multiple of significance, no rounding occurs. ✓
D. Text is always ignored

Explanation: Correct: Regardless of the sign of number, a value is rounded up when adjusted away from zero. If number is an exact multiple of significance, no rounding occurs.

10. What usually causes #VALUE! in =CEILING?

A. If either argument is nonnumeric, CEILING returns the #VALUE! error value. ✓
B. Only works in old versions
C. Select entire column for best performance
D. Output is always a dynamic array

Explanation: If either argument is nonnumeric, CEILING returns the #VALUE! error value. — Fix: برای هر دو آرگومان مقدار عددی وارد کنید.