Compatibility =NEGBINOMDIST(number_f,number_s,probability_s)

Quiz =NEGBINOMDIST — 10 Questions

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

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

← NEGBINOMDIST ▦ Practice in Playground

Progress — 10 questions 1 of 10

Question 1 of 10 1/10

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

Question 2 of 10 2/10

Which formula is a valid example of =NEGBINOMDIST?

Question 3 of 10 3/10

Which statement about =NEGBINOMDIST is correct?

Question 4 of 10 4/10

Does =NEGBINOMDIST return a dynamic array?

Question 5 of 10 5/10

How many arguments does =NEGBINOMDIST have in total?

Question 6 of 10 6/10

Which category does =NEGBINOMDIST belong to?

Question 7 of 10 7/10

Which function is NOT related to =NEGBINOMDIST?

Question 8 of 10 8/10

Is argument “number_s” required in =NEGBINOMDIST?

Question 9 of 10 9/10

How many required arguments does =NEGBINOMDIST have?

Question 10 of 10 10/10

What is the type of argument “probability_s” in =NEGBINOMDIST?

Click a question to see the answer.

1. What is the fix for #NUM! in =NEGBINOMDIST?

A. یک یا چند آرگومان غیرعددی است.
B. Output is always a dynamic array
C. Only works in old versions
D. Enter a value between 0 and 1 ✓

Explanation: If probability_s < 0 or if probability > 1, NEGBINOMDIST returns the #NUM! error value. If number_f < 0 or number_s < 1, NEGBINOMDIST returns the #NUM! error value. — Fix: Enter a value between 0 and 1

2. Which formula is a valid example of =NEGBINOMDIST?

A. NEGBINOMDIST(A2,A3,A4)
B. =NEGBINOMDIST(A2,A3,A4) ✓
C. =NEGBINOMDIST(A2,A3,A4, 0)
D. =FORECAST(A2,A3,A4)

Explanation: Correct example: =NEGBINOMDIST(A2,A3,A4)

3. Which statement about =NEGBINOMDIST is correct?

A. Number_f and number_s are truncated to integers.
B. Volatile and recalculates every time
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.

4. Does =NEGBINOMDIST return a dynamic array?

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

Explanation: NEGBINOMDIST does not spill.

5. How many arguments does =NEGBINOMDIST have in total?

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

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

6. Which category does =NEGBINOMDIST belong to?

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

Explanation: Category is “Compatibility”.

7. Which function is NOT related to =NEGBINOMDIST?

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

Explanation: “PIVOTBY” is not related to NEGBINOMDIST.

8. Is argument “number_s” required in =NEGBINOMDIST?

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

Explanation: “number_s” is required.

9. How many required arguments does =NEGBINOMDIST have?

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

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

10. What is the type of argument “probability_s” in =NEGBINOMDIST?

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

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