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

How many optional arguments does =FLOOR.PRECISE have?

Question 2 of 10 2/10

Which function is NOT related to =FLOOR.PRECISE?

Question 3 of 10 3/10

Which is the correct syntax of =FLOOR.PRECISE?

Question 4 of 10 4/10

Which function is related to =FLOOR.PRECISE?

Question 5 of 10 5/10

Does =FLOOR.PRECISE return a dynamic array?

Question 6 of 10 6/10

Which statement about =FLOOR.PRECISE is correct?

Question 7 of 10 7/10

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

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 required arguments does =FLOOR.PRECISE have?

Click a question to see the answer.

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

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

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

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

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

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

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

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

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

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

A. MIRR
B. DVAR
C. SUMIFS
D. ABS ✓

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

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

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

Explanation: FLOOR.PRECISE does not spill.

6. 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. Output is always a dynamic array
C. Requires add-in
D. Select entire column for best performance

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. Is argument “significance” required in =FLOOR.PRECISE?

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

Explanation: “significance” is optional.

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

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

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

9. Is =FLOOR.PRECISE volatile?

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

Explanation: FLOOR.PRECISE is not volatile.

10. 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).