Compatibility =NORMSDIST(z)

Quiz =NORMSDIST — 10 Questions

10 quiz questions about =NORMSDIST — test syntax, arguments, examples & errors!

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

← NORMSDIST ▦ Practice in Playground

Progress — 10 questions 1 of 10

Question 1 of 10 1/10

Is =NORMSDIST volatile?

Question 2 of 10 2/10

What is the output type of =NORMSDIST?

Question 3 of 10 3/10

Since which Excel version is =NORMSDIST available?

Question 4 of 10 4/10

Which function is related to =NORMSDIST?

Question 5 of 10 5/10

Which use case fits =NORMSDIST?

Question 6 of 10 6/10

Which category does =NORMSDIST belong to?

Question 7 of 10 7/10

How many required arguments does =NORMSDIST have?

Question 8 of 10 8/10

Which statement about =NORMSDIST is correct?

Question 9 of 10 9/10

Which formula is a valid example of =NORMSDIST?

Question 10 of 10 10/10

Which is the correct syntax of =NORMSDIST?

Click a question to see the answer.

1. Is =NORMSDIST volatile?

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

Explanation: NORMSDIST is not volatile.

2. What is the output type of =NORMSDIST?

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

Explanation: Output is “Number”.

3. Since which Excel version is =NORMSDIST available?

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

Explanation: Version: “Excel 2007 (Compatibility)”.

4. Which function is related to =NORMSDIST?

A. ASINH
B. PRODUCT
C. FORECAST ✓
D. CLEAN

Explanation: “FORECAST” is related to NORMSDIST.

5. Which use case fits =NORMSDIST?

A. Conditional Logic
B. Reporting ✓
C. Ranking & Top N
D. Text Manipulation

Explanation: Use case “Reporting” fits NORMSDIST.

6. Which category does =NORMSDIST belong to?

A. Information
B. Date & Time
C. Engineering
D. Compatibility ✓

Explanation: Category is “Compatibility”.

7. How many required arguments does =NORMSDIST have?

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

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

8. Which statement about =NORMSDIST is correct?

A. Select entire column for best performance
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. ✓
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.

9. Which formula is a valid example of =NORMSDIST?

A. =FORECAST(1.333333)
B. =NORMSDIST(1.333333, 0)
C. NORMSDIST(1.333333)
D. =NORMSDIST(1.333333) ✓

Explanation: Correct example: =NORMSDIST(1.333333)

10. Which is the correct syntax of =NORMSDIST?

A. NORMSDIST(z)
B. =NORMSDIST(z, 0)
C. =NORMSDIST(z) ✓
D. =FORECAST(z)

Explanation: Correct syntax: =NORMSDIST(z)