Compatibility =NORMSINV(probability)

Quiz =NORMSINV — 10 Questions

10 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 — 10 questions 1 of 10

Question 1 of 10 1/10

What is the output type of =NORMSINV?

Question 2 of 10 2/10

How many required arguments does =NORMSINV have?

Question 3 of 10 3/10

Which statement about =NORMSINV is correct?

Question 4 of 10 4/10

Which formula is a valid example of =NORMSINV?

Question 5 of 10 5/10

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

Question 6 of 10 6/10

Is =NORMSINV volatile?

Question 7 of 10 7/10

How many optional arguments does =NORMSINV have?

Question 8 of 10 8/10

Which category does =NORMSINV belong to?

Question 9 of 10 9/10

Which function is NOT related to =NORMSINV?

Question 10 of 10 10/10

Which is the correct syntax of =NORMSINV?

Click a question to see the answer.

1. What is the output type of =NORMSINV?

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

Explanation: Output is “Number”.

2. How many required arguments does =NORMSINV have?

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

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

3. Which statement about =NORMSINV is correct?

A. Requires add-in
B. 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. ✓
C. Output is always a dynamic array
D. Only works in old versions

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.

4. Which formula is a valid example of =NORMSINV?

A. =NORMSINV(0.9088, 0)
B. =FORECAST(0.9088)
C. NORMSINV(0.9088)
D. =NORMSINV(0.9088) ✓

Explanation: Correct example: =NORMSINV(0.9088)

5. What is the fix for #VALUE! in =NORMSINV?

A. برای Probability یک مقدار عددی وارد کنید. ✓
B. Select entire column for best performance
C. Requires add-in
D. Volatile and recalculates every time

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

6. Is =NORMSINV volatile?

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

Explanation: NORMSINV is not volatile.

7. How many optional arguments does =NORMSINV have?

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

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

8. Which category does =NORMSINV belong to?

A. Database
B. Compatibility ✓
C. Information
D. Text

Explanation: Category is “Compatibility”.

9. Which function is NOT related to =NORMSINV?

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

Explanation: “HIDDEN” is not related to NORMSINV.

10. Which is the correct syntax of =NORMSINV?

A. =FORECAST(probability)
B. =NORMSINV(probability) ✓
C. =NORMSINV(probability, 0)
D. NORMSINV(probability)

Explanation: Correct syntax: =NORMSINV(probability)