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

Quiz =FLOOR.PRECISE — 10 Questions

10 quiz questions about =FLOOR.PRECISE — test syntax, arguments, examples & errors!

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

← FLOOR.PRECISE ▦ Practice in Playground

Progress — 10 questions 1 of 10

Question 1 of 10 1/10

Which category does =FLOOR.PRECISE belong to?

Question 2 of 10 2/10

How many optional arguments does =FLOOR.PRECISE have?

Question 3 of 10 3/10

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

Question 4 of 10 4/10

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

Question 5 of 10 5/10

Since which Excel version is =FLOOR.PRECISE available?

Question 6 of 10 6/10

Which use case fits =FLOOR.PRECISE?

Question 7 of 10 7/10

Which statement about =FLOOR.PRECISE is correct?

Question 8 of 10 8/10

How many required arguments does =FLOOR.PRECISE have?

Question 9 of 10 9/10

Does =FLOOR.PRECISE return a dynamic array?

Question 10 of 10 10/10

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

Click a question to see the answer.

1. Which category does =FLOOR.PRECISE belong to?

A. Math & Trig ✓
B. Statistical
C. Cube
D. Lookup & Reference

Explanation: Category is “Math & Trig”.

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

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

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

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

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

Explanation: Argument #2 is “significance”.

4. How many arguments does =FLOOR.PRECISE have in total?

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

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

5. Since which Excel version is =FLOOR.PRECISE available?

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

Explanation: Version: “Excel 2013”.

6. Which use case fits =FLOOR.PRECISE?

A. Probability & Hypothesis Testing
B. Rounding & Numeric ✓
C. Advanced Formulas
D. Date & Time Calculations

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

7. Which statement about =FLOOR.PRECISE is correct?

A. The absolute value of the multiple is used, so that the FLOOR.PRECISE function returns the mathematical floor irrespective of the signs of number and significance. ✓
B. Only works in old versions
C. Requires add-in
D. Output is always a dynamic array

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

8. How many required arguments does =FLOOR.PRECISE have?

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

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

9. Does =FLOOR.PRECISE return a dynamic array?

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

Explanation: FLOOR.PRECISE does not spill.

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

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

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