Compatibility =NEGBINOMDIST(number_f,number_s,probability_s)

Quiz =NEGBINOMDIST — 15 Questions

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

Question 1 of 15 1/15

Is argument “number_s” required in =NEGBINOMDIST?

Question 2 of 15 2/15

Which formula is a valid example of =NEGBINOMDIST?

Question 3 of 15 3/15

Which statement about =NEGBINOMDIST is correct?

Question 4 of 15 4/15

In =NEGBINOMDIST, which is argument #2?

Question 5 of 15 5/15

How many arguments does =NEGBINOMDIST have in total?

Question 6 of 15 6/15

How many required arguments does =NEGBINOMDIST have?

Question 7 of 15 7/15

How many optional arguments does =NEGBINOMDIST have?

Question 8 of 15 8/15

Is argument “probability_s” required in =NEGBINOMDIST?

Question 9 of 15 9/15

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

Question 10 of 15 10/15

What is the output type of =NEGBINOMDIST?

Question 11 of 15 11/15

Which function is NOT related to =NEGBINOMDIST?

Question 12 of 15 12/15

Is argument “number_f” required in =NEGBINOMDIST?

Question 13 of 15 13/15

Which category does =NEGBINOMDIST belong to?

Question 14 of 15 14/15

Is =NEGBINOMDIST volatile?

Question 15 of 15 15/15

Which use case fits =NEGBINOMDIST?

Click a question to see the answer.

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

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

Explanation: “number_s” is required.

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

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

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

3. Which statement about =NEGBINOMDIST is correct?

A. 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. ✓
B. Volatile and recalculates every time
C. Requires add-in
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.

4. In =NEGBINOMDIST, which is argument #2?

A. range
B. probability_s
C. value
D. number_s ✓

Explanation: Argument #2 is “number_s”.

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. How many required arguments does =NEGBINOMDIST have?

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

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

7. How many optional arguments does =NEGBINOMDIST have?

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

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

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

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

Explanation: “probability_s” is required.

9. What is the type of argument “number_f” in =NEGBINOMDIST?

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

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

10. What is the output type of =NEGBINOMDIST?

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

Explanation: Output is “Number”.

11. Which function is NOT related to =NEGBINOMDIST?

A. FORECAST
B. MODE
C. ERFC.PRECISE ✓
D. PERCENTILE

Explanation: “ERFC.PRECISE” is not related to NEGBINOMDIST.

12. Is argument “number_f” required in =NEGBINOMDIST?

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

Explanation: “number_f” is required.

13. Which category does =NEGBINOMDIST belong to?

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

Explanation: Category is “Compatibility”.

14. Is =NEGBINOMDIST volatile?

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

Explanation: NEGBINOMDIST is not volatile.

15. Which use case fits =NEGBINOMDIST?

A. Conditional Logic
B. Reporting ✓
C. Numbering & Sample Data
D. Reshape Tables

Explanation: Use case “Reporting” fits NEGBINOMDIST.