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

What is the output type of =FLOOR.PRECISE?

Question 2 of 10 2/10

Which is the correct syntax of =FLOOR.PRECISE?

Question 3 of 10 3/10

Which function is related to =FLOOR.PRECISE?

Question 4 of 10 4/10

Which statement about =FLOOR.PRECISE is correct?

Question 5 of 10 5/10

Which function is NOT related to =FLOOR.PRECISE?

Question 6 of 10 6/10

Since which Excel version is =FLOOR.PRECISE available?

Question 7 of 10 7/10

Does =FLOOR.PRECISE return a dynamic array?

Question 8 of 10 8/10

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

Question 9 of 10 9/10

Is =FLOOR.PRECISE volatile?

Question 10 of 10 10/10

How many optional arguments does =FLOOR.PRECISE have?

Click a question to see the answer.

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

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

Explanation: Output is “Number”.

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

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

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

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

A. IF
B. CUBEKPIMEMBER
C. ABS ✓
D. CEILING.PRECISE

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

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

A. Volatile and recalculates every time
B. Output is always a dynamic array
C. Requires add-in
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.

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

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

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

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

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

Explanation: Version: “Excel 2013”.

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

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

Explanation: FLOOR.PRECISE does not spill.

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, 0)
D. FLOOR.PRECISE(-3.2,-1)

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

9. Is =FLOOR.PRECISE volatile?

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

Explanation: FLOOR.PRECISE is not volatile.

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

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

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