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

Which is the correct syntax of =FLOOR.PRECISE?

Question 2 of 15 2/15

Since which Excel version is =FLOOR.PRECISE available?

Question 3 of 15 3/15

Does =FLOOR.PRECISE return a dynamic array?

Question 4 of 15 4/15

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

Question 5 of 15 5/15

Is =FLOOR.PRECISE volatile?

Question 6 of 15 6/15

Which statement about =FLOOR.PRECISE is correct?

Question 7 of 15 7/15

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

Question 8 of 15 8/15

How many required arguments does =FLOOR.PRECISE have?

Question 9 of 15 9/15

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

Question 10 of 15 10/15

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

Question 11 of 15 11/15

Which function is NOT related to =FLOOR.PRECISE?

Question 12 of 15 12/15

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

Question 13 of 15 13/15

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

Question 14 of 15 14/15

What is the output type of =FLOOR.PRECISE?

Question 15 of 15 15/15

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

Click a question to see the answer.

1. 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])

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

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

Explanation: Version: “Excel 2013”.

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

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

Explanation: FLOOR.PRECISE does not spill.

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

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

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

5. Is =FLOOR.PRECISE volatile?

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

Explanation: FLOOR.PRECISE is not volatile.

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

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

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.

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

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

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

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

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

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

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

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

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

10. Is argument “number” required in =FLOOR.PRECISE?

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

Explanation: “number” is required.

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

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

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

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

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

Explanation: Argument #2 is “significance”.

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

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

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

14. What is the output type of =FLOOR.PRECISE?

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

Explanation: Output is “Number”.

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

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

Explanation: “significance” is optional.