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

Is argument “mean” required in =NORMINV?

Question 3 of 15 3/15

How many optional arguments does =NORMINV have?

Question 4 of 15 4/15

Which function is related to =NORMINV?

Question 5 of 15 5/15

Since which Excel version is =NORMINV available?

Question 6 of 15 6/15

Which function is NOT related to =NORMINV?

Question 7 of 15 7/15

How many required arguments does =NORMINV have?

Question 8 of 15 8/15

What usually causes #NUM! in =NORMINV?

Question 9 of 15 9/15

What is the output type of =NORMINV?

Question 10 of 15 10/15

What is the type of argument “standard_dev” in =NORMINV?

Question 11 of 15 11/15

What is the type of argument “mean” in =NORMINV?

Question 12 of 15 12/15

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

Question 13 of 15 13/15

Which category does =NORMINV belong to?

Question 14 of 15 14/15

Which statement about =NORMINV is correct?

Question 15 of 15 15/15

Does =NORMINV return a dynamic array?

Click a question to see the answer.

1. Is =NORMINV volatile?

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

Explanation: NORMINV is not volatile.

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

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

Explanation: “mean” is required.

3. How many optional arguments does =NORMINV have?

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

Explanation: =NORMINV has 3 required, 0 optional (3 total).

4. Which function is related to =NORMINV?

A. AVEDEV ✓
B. TEXTJOIN
C. UPPER
D. T.INV

Explanation: “AVEDEV” is related to NORMINV.

5. Since which Excel version is =NORMINV available?

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

Explanation: Version: “All versions”.

6. Which function is NOT related to =NORMINV?

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

Explanation: “ISPMT” is not related to NORMINV.

7. How many required arguments does =NORMINV have?

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

Explanation: =NORMINV has 3 required, 0 optional (3 total).

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

A. Only works in old versions
B. Text is always ignored
C. If probability <= 0 or if probability >= 1, NORMINV returns the #NUM! error value. If standard_dev ≤ 0, NORMINV returns the #NUM! error value. ✓
D. جستجوی تکراری پس از 100 تکرار همگرا نشده است.

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

9. What is the output type of =NORMINV?

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

Explanation: Output is “Value”.

10. What is the type of argument “standard_dev” in =NORMINV?

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

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

11. What is the type of argument “mean” in =NORMINV?

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

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

12. What is the fix for #N/A in =NORMINV?

A. Requires add-in
B. Only works in old versions
C. مقدار probability خارج از بازه (0,1) است یا standard_dev کوچک‌تر یا مساوی صفر است.
D. مقادیر ورودی به‌ویژه probability را بررسی کنید و دوباره تلاش کنید؛ در صورت تکرار، ورودی‌ها را ساده‌تر کنید. ✓

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

13. Which category does =NORMINV belong to?

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

Explanation: Category is “Statistical”.

14. 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. Only works in old versions
D. Output is always a dynamic array

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.

15. Does =NORMINV return a dynamic array?

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

Explanation: NORMINV does not spill.