Compatibility =NORMSINV(probability)

Quiz =NORMSINV — 15 Questions

15 quiz questions about =NORMSINV — test syntax, arguments, examples & errors!

Questions: 10 questions 15 questions Random 10 or 15 questions from the pool + shuffled options each time

← NORMSINV ▦ Practice in Playground

Progress — 15 questions 1 of 15

Question 1 of 15 1/15

Which function is related to =NORMSINV?

Question 2 of 15 2/15

How many optional arguments does =NORMSINV have?

Question 3 of 15 3/15

Does =NORMSINV return a dynamic array?

Question 4 of 15 4/15

Is argument “probability” required in =NORMSINV?

Question 5 of 15 5/15

What is the type of argument “probability” in =NORMSINV?

Question 6 of 15 6/15

How many arguments does =NORMSINV have in total?

Question 7 of 15 7/15

Which function is NOT related to =NORMSINV?

Question 8 of 15 8/15

In =NORMSINV, which is argument #1?

Question 9 of 15 9/15

What usually causes #VALUE! in =NORMSINV?

Question 10 of 15 10/15

Which statement about =NORMSINV is correct?

Question 11 of 15 11/15

How many required arguments does =NORMSINV have?

Question 12 of 15 12/15

Which category does =NORMSINV belong to?

Question 13 of 15 13/15

Which use case fits =NORMSINV?

Question 14 of 15 14/15

What is the fix for #N/A in =NORMSINV?

Question 15 of 15 15/15

What is the fix for #NUM! in =NORMSINV?

Click a question to see the answer.

1. Which function is related to =NORMSINV?

A. NORM.S.INV
B. BAHTTEXT
C. FORECAST ✓
D. SERIESSUM

Explanation: “FORECAST” is related to NORMSINV.

2. How many optional arguments does =NORMSINV have?

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

Explanation: =NORMSINV has 1 required, 0 optional (1 total).

3. Does =NORMSINV return a dynamic array?

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

Explanation: NORMSINV does not spill.

4. Is argument “probability” required in =NORMSINV?

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

Explanation: “probability” is required.

5. What is the type of argument “probability” in =NORMSINV?

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

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

6. How many arguments does =NORMSINV have in total?

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

Explanation: =NORMSINV has 1 required, 0 optional (1 total).

7. Which function is NOT related to =NORMSINV?

A. FORECAST
B. PERCENTILE
C. ISNA ✓
D. MODE

Explanation: “ISNA” is not related to NORMSINV.

8. In =NORMSINV, which is argument #1?

A. probability ✓
B. lookup_value
C. value
D. criteria

Explanation: Argument #1 is “probability”.

9. What usually causes #VALUE! in =NORMSINV?

A. Volatile and recalculates every time
B. Requires add-in
C. Select entire column for best performance
D. If Probability is nonnumeric, NORMSINV returns the #VALUE! error value. ✓

Explanation: If Probability is nonnumeric, NORMSINV returns the #VALUE! error value. — Fix: برای Probability یک مقدار عددی وارد کنید.

10. Which statement about =NORMSINV is correct?

A. Output is always a dynamic array
B. Text is always ignored
C. This function has been replaced with one or more new functions that may provide improved accuracy and whose names better reflect their usage. Although this function is still available for backward compatibility, you should consider using the new functions from now on, because this function may not be available in future versions of Excel. For more information about the new function, see NORM.S.INV function. ✓
D. Requires add-in

Explanation: Correct: This function has been replaced with one or more new functions that may provide improved accuracy and whose names better reflect their usage. Although this function is still available for backward compatibility, you should consider using the new functions from now on, because this function may not be available in future versions of Excel. For more information about the new function, see NORM.S.INV function.

11. How many required arguments does =NORMSINV have?

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

Explanation: =NORMSINV has 1 required, 0 optional (1 total).

12. Which category does =NORMSINV belong to?

A. Date & Time
B. Database
C. Compatibility ✓
D. Statistical

Explanation: Category is “Compatibility”.

13. Which use case fits =NORMSINV?

A. Error Handling
B. External Data, Web & Cube
C. Reporting ✓
D. Probability & Hypothesis Testing

Explanation: Use case “Reporting” fits NORMSINV.

14. What is the fix for #N/A in =NORMSINV?

A. Output is always a dynamic array
B. مقدار Probability را بررسی کنید و در صورت تکرار، ورودی را تغییر دهید. ✓
C. Select entire column for best performance
D. Volatile and recalculates every time

Explanation: If the search has not converged after 100 iterations, the function returns the #N/A error value. — Fix: مقدار Probability را بررسی کنید و در صورت تکرار، ورودی را تغییر دهید.

15. What is the fix for #NUM! in =NORMSINV?

A. Text is always ignored
B. مقدار Probability غیرعددی است.
C. Enter a value between 0 and 1 ✓
D. Only works in old versions

Explanation: If Probability <= 0 or if Probability >= 1, NORMSINV returns the #NUM! error value. — Fix: Enter a value between 0 and 1