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 statement about =FLOOR.PRECISE is correct?

Question 2 of 15 2/15

Which function is related to =FLOOR.PRECISE?

Question 3 of 15 3/15

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

Question 4 of 15 4/15

Which use case fits =FLOOR.PRECISE?

Question 5 of 15 5/15

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

Question 6 of 15 6/15

Which category does =FLOOR.PRECISE belong to?

Question 7 of 15 7/15

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

Question 8 of 15 8/15

Which function is NOT related to =FLOOR.PRECISE?

Question 9 of 15 9/15

Which is the correct syntax of =FLOOR.PRECISE?

Question 10 of 15 10/15

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

Question 11 of 15 11/15

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

Question 12 of 15 12/15

How many required arguments does =FLOOR.PRECISE have?

Question 13 of 15 13/15

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

Question 14 of 15 14/15

What is the output type of =FLOOR.PRECISE?

Question 15 of 15 15/15

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

Click a question to see the answer.

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

A. Only works in old versions
B. Text is always ignored
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. 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.

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

A. CUBEKPIMEMBER
B. N
C. NORMSDIST
D. ABS ✓

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

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

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

Explanation: Argument #2 is “significance”.

4. Which use case fits =FLOOR.PRECISE?

A. Sort, Filter & Dedupe
B. Error Handling
C. Rounding & Numeric ✓
D. Descriptive Statistics

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

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

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

Explanation: Argument #1 is “number”.

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

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

Explanation: Category is “Math & Trig”.

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Explanation: “number” is required.

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

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

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

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

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

Explanation: “significance” is optional.

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

A. Text
B. Logical
C. Reference
D. Number ✓

Explanation: Output is “Number”.

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

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

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