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

Quiz =FLOOR.PRECISE — 15 Questions

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

Question 1 of 15 1/15

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

Question 2 of 15 2/15

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

Question 3 of 15 3/15

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

Question 4 of 15 4/15

Which function is NOT related to =FLOOR.PRECISE?

Question 5 of 15 5/15

Which category does =FLOOR.PRECISE belong to?

Question 6 of 15 6/15

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

Question 7 of 15 7/15

Since which Excel version is =FLOOR.PRECISE available?

Question 8 of 15 8/15

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

Question 9 of 15 9/15

How many required arguments does =FLOOR.PRECISE have?

Question 10 of 15 10/15

Which is the correct syntax of =FLOOR.PRECISE?

Question 11 of 15 11/15

Which use case fits =FLOOR.PRECISE?

Question 12 of 15 12/15

Which statement about =FLOOR.PRECISE is correct?

Question 13 of 15 13/15

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

Question 14 of 15 14/15

Does =FLOOR.PRECISE return a dynamic array?

Question 15 of 15 15/15

Which function is related to =FLOOR.PRECISE?

Click a question to see the answer.

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

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

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

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

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

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

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

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

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

4. Which function is NOT related to =FLOOR.PRECISE?

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

Explanation: “EDATE” is not related to FLOOR.PRECISE.

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

A. Web
B. Information
C. Engineering
D. Math & Trig ✓

Explanation: Category is “Math & Trig”.

6. In =FLOOR.PRECISE, which is argument #1?

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

Explanation: Argument #1 is “number”.

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

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

Explanation: Version: “Excel 2013”.

8. Which formula is a valid example of =FLOOR.PRECISE?

A. =FLOOR.PRECISE(-3.2,-1) ✓
B. =ABS(-3.2,-1)
C. FLOOR.PRECISE(-3.2,-1)
D. =FLOOR.PRECISE(-3.2,-1, 0)

Explanation: Correct example: =FLOOR.PRECISE(-3.2,-1)

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

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

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

10. Which is the correct syntax of =FLOOR.PRECISE?

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

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

11. Which use case fits =FLOOR.PRECISE?

A. Rounding & Numeric ✓
B. Ranking & Top N
C. Reshape Tables
D. Financial Calculations

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

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

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

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.

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

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

Explanation: “significance” is optional.

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

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

Explanation: FLOOR.PRECISE does not spill.

15. Which function is related to =FLOOR.PRECISE?

A. TOROW
B. LOGNORMDIST
C. MIN
D. ABS ✓

Explanation: “ABS” is related to FLOOR.PRECISE.