Statistical =NORMINV(probability,mean,standard_dev)

Quiz =NORMINV — 15 Questions

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

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

← NORMINV ▦ Practice in Playground

Progress — 15 questions 1 of 15

Question 1 of 15 1/15

Is =NORMINV volatile?

Question 2 of 15 2/15

What usually causes #NUM! in =NORMINV?

Question 3 of 15 3/15

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

Question 4 of 15 4/15

Is argument “standard_dev” required in =NORMINV?

Question 5 of 15 5/15

In =NORMINV, which is argument #1?

Question 6 of 15 6/15

Does =NORMINV return a dynamic array?

Question 7 of 15 7/15

Is argument “mean” required in =NORMINV?

Question 8 of 15 8/15

Which statement about =NORMINV is correct?

Question 9 of 15 9/15

What usually causes #VALUE! in =NORMINV?

Question 10 of 15 10/15

Which function is NOT related to =NORMINV?

Question 11 of 15 11/15

Since which Excel version is =NORMINV available?

Question 12 of 15 12/15

Which category does =NORMINV belong to?

Question 13 of 15 13/15

Which use case fits =NORMINV?

Question 14 of 15 14/15

Which function is related to =NORMINV?

Question 15 of 15 15/15

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

Click a question to see the answer.

1. Is =NORMINV volatile?

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

Explanation: NORMINV is not volatile.

2. What usually causes #NUM! in =NORMINV?

A. Requires add-in
B. Volatile and recalculates every time
C. Output is always a dynamic array
D. If probability <= 0 or if probability >= 1, NORMINV returns the #NUM! error value. If standard_dev ≤ 0, NORMINV returns the #NUM! error value. ✓

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

3. What is the fix for #VALUE! in =NORMINV?

A. Requires add-in
B. جستجوی تکراری پس از 100 تکرار همگرا نشده است.
C. همه آرگومان‌ها را به‌صورت عدد وارد کنید. ✓
D. Only works in old versions

Explanation: If any argument is nonnumeric, NORMINV returns the #VALUE! error value. — Fix: همه آرگومان‌ها را به‌صورت عدد وارد کنید.

4. Is argument “standard_dev” required in =NORMINV?

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

Explanation: “standard_dev” is required.

5. In =NORMINV, which is argument #1?

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

Explanation: Argument #1 is “probability”.

6. Does =NORMINV return a dynamic array?

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

Explanation: NORMINV does not spill.

7. Is argument “mean” required in =NORMINV?

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

Explanation: “mean” is required.

8. Which statement about =NORMINV is correct?

A. Text is always ignored
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.INV function. ✓
C. Volatile and recalculates every time
D. If mean = 0 and standard_dev = 1, NORMINV uses the standard normal distribution (see NORMSINV).

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.INV function.

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

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

Explanation: If any argument is nonnumeric, NORMINV returns the #VALUE! error value. — Fix: همه آرگومان‌ها را به‌صورت عدد وارد کنید.

10. Which function is NOT related to =NORMINV?

A. AVERAGE
B. SLOPE ✓
C. AVEDEV
D. AVERAGEA

Explanation: “SLOPE” is not related to NORMINV.

11. Since which Excel version is =NORMINV available?

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

Explanation: Version: “All versions”.

12. Which category does =NORMINV belong to?

A. Cube
B. Math & Trig
C. Information
D. Statistical ✓

Explanation: Category is “Statistical”.

13. Which use case fits =NORMINV?

A. Scientific & Unit Conversion
B. Daily Tasks ✓
C. Reporting
D. Worksheet Info & Navigation

Explanation: Use case “Daily Tasks” fits NORMINV.

14. Which function is related to =NORMINV?

A. ODDFYIELD
B. ZTEST
C. AVEDEV ✓
D. TOCOL

Explanation: “AVEDEV” is related to NORMINV.

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

A. Enter a value between 0 and 1 ✓
B. جستجوی تکراری پس از 100 تکرار همگرا نشده است.
C. Select entire column for best performance
D. Only works in old versions