Math & Trig =FLOOR.MATH(number, significance, mode)

Quiz =FLOOR.MATH — 15 Questions

15 quiz questions about =FLOOR.MATH — test syntax, arguments, examples & errors!

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

← FLOOR.MATH ▦ Practice in Playground

Progress — 15 questions 1 of 15

Question 1 of 15 1/15

Which function is NOT related to =FLOOR.MATH?

Question 2 of 15 2/15

In =FLOOR.MATH, which is argument #3?

Question 3 of 15 3/15

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

Question 4 of 15 4/15

In =FLOOR.MATH, which is argument #2?

Question 5 of 15 5/15

Which is the correct syntax of =FLOOR.MATH?

Question 6 of 15 6/15

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

Question 7 of 15 7/15

Is argument “significance” required in =FLOOR.MATH?

Question 8 of 15 8/15

How many arguments does =FLOOR.MATH have in total?

Question 9 of 15 9/15

Which formula is a valid example of =FLOOR.MATH?

Question 10 of 15 10/15

Which category does =FLOOR.MATH belong to?

Question 11 of 15 11/15

What is the output type of =FLOOR.MATH?

Question 12 of 15 12/15

Which statement about =FLOOR.MATH is correct?

Question 13 of 15 13/15

Is argument “number” required in =FLOOR.MATH?

Question 14 of 15 14/15

How many required arguments does =FLOOR.MATH have?

Question 15 of 15 15/15

Since which Excel version is =FLOOR.MATH available?

Click a question to see the answer.

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

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

Explanation: “ERFC” is not related to FLOOR.MATH.

2. In =FLOOR.MATH, which is argument #3?

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

Explanation: Argument #3 is “mode”.

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

A. Array
B. Number ✓
C. Text
D. Value

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

4. In =FLOOR.MATH, which is argument #2?

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

Explanation: Argument #2 is “significance”.

5. Which is the correct syntax of =FLOOR.MATH?

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

Explanation: Correct syntax: =FLOOR.MATH(number, significance, mode)

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

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

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

7. Is argument “significance” required in =FLOOR.MATH?

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

Explanation: “significance” is optional.

8. How many arguments does =FLOOR.MATH have in total?

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

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

9. Which formula is a valid example of =FLOOR.MATH?

A. FLOOR.MATH(24.3,5)
B. =FLOOR.MATH(24.3,5, 0)
C. =FLOOR.MATH(24.3,5) ✓
D. =CEILING-MATH(24.3,5)

Explanation: Correct example: =FLOOR.MATH(24.3,5)

10. Which category does =FLOOR.MATH belong to?

A. Financial
B. Lookup & Reference
C. Database
D. Math & Trig ✓

Explanation: Category is “Math & Trig”.

11. What is the output type of =FLOOR.MATH?

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

Explanation: Output is “Number”.

12. Which statement about =FLOOR.MATH is correct?

A. The Significance argument rounds the number down to the nearest integer that is a multiple of the significance specified. The exception is where the number to be rounded is an integer. For example, for a Significance of 3, the number is rounded down to the next integer that is a multiple of 3.
B. Requires add-in
C. By default, positive numbers with decimal portions are rounded down to the nearest integer. For example, 6.3 is rounded down to 6, using the default Significance (1). ✓
D. If Number divided by a Significance of 2 or greater results in a remainder, the result is rounded down.

Explanation: Correct: By default, positive numbers with decimal portions are rounded down to the nearest integer. For example, 6.3 is rounded down to 6, using the default Significance (1).

13. Is argument “number” required in =FLOOR.MATH?

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

Explanation: “number” is required.

14. How many required arguments does =FLOOR.MATH have?

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

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

15. Since which Excel version is =FLOOR.MATH available?

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

Explanation: Version: “Excel 2013”.