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

Quiz =CEILING.MATH — 10 Questions

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

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

← CEILING.MATH ▦ Practice in Playground

Progress — 10 questions 1 of 10

Question 1 of 10 1/10

Which function is NOT related to =CEILING.MATH?

Question 2 of 10 2/10

Which is the correct syntax of =CEILING.MATH?

Question 3 of 10 3/10

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

Question 4 of 10 4/10

Which category does =CEILING.MATH belong to?

Question 5 of 10 5/10

Which statement about =CEILING.MATH is correct?

Question 6 of 10 6/10

Is =CEILING.MATH volatile?

Question 7 of 10 7/10

How many optional arguments does =CEILING.MATH have?

Question 8 of 10 8/10

Which use case fits =CEILING.MATH?

Question 9 of 10 9/10

Is argument “mode” required in =CEILING.MATH?

Question 10 of 10 10/10

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

Click a question to see the answer.

1. Which function is NOT related to =CEILING.MATH?

A. CEILING
B. SUMSQ ✓
C. FLOOR-MATH
D. MROUND

Explanation: “SUMSQ” is not related to CEILING.MATH.

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

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

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

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

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

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

4. Which category does =CEILING.MATH belong to?

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

Explanation: Category is “Math & Trig”.

5. Which statement about =CEILING.MATH is correct?

A. By default, significance is +1 for positive numbers and -1 for negative numbers. ✓
B. The mode argument does not affect positive numbers.
C. By default, positive numbers with decimal portions are rounded up to the nearest integer. For example, 6.3 is rounded up to 7.
D. Using the significance and mode arguments, you can change the direction of the rounding for negative numbers. For example, rounding -6.3 to a significance of 1 with a mode of 1 will round away from 0, to -7. Combinations of Significance and Mode values can affect rounding of negative numbers in different ways.

Explanation: Correct: By default, significance is +1 for positive numbers and -1 for negative numbers.

6. Is =CEILING.MATH volatile?

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

Explanation: CEILING.MATH is not volatile.

7. How many optional arguments does =CEILING.MATH have?

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

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

8. Which use case fits =CEILING.MATH?

A. Investment Appraisal
B. Rounding & Numeric ✓
C. Text Manipulation
D. Depreciation

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

9. Is argument “mode” required in =CEILING.MATH?

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

Explanation: “mode” is optional.

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

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

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