Statistical =HYPGEOM.DIST(sample_s,number_sample,population_s,number_pop,cumulative)

Quiz =HYPGEOM.DIST — 10 Questions

10 quiz questions about =HYPGEOM.DIST — test syntax, arguments, examples & errors!

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

← HYPGEOM.DIST ▦ Practice in Playground

Progress — 10 questions 1 of 10

Question 1 of 10 1/10

Is argument “number_pop” required in =HYPGEOM.DIST?

Question 2 of 10 2/10

In =HYPGEOM.DIST, which is argument #3?

Question 3 of 10 3/10

In =HYPGEOM.DIST, which is argument #2?

Question 4 of 10 4/10

Which use case fits =HYPGEOM.DIST?

Question 5 of 10 5/10

What usually causes #VALUE! in =HYPGEOM.DIST?

Question 6 of 10 6/10

Which statement about =HYPGEOM.DIST is correct?

Question 7 of 10 7/10

What is the fix for #VALUE! in =HYPGEOM.DIST?

Question 8 of 10 8/10

Is argument “number_sample” required in =HYPGEOM.DIST?

Question 9 of 10 9/10

What is the fix for #NUM! in =HYPGEOM.DIST?

Question 10 of 10 10/10

What usually causes #NUM! in =HYPGEOM.DIST?

Click a question to see the answer.

1. Is argument “number_pop” required in =HYPGEOM.DIST?

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

Explanation: “number_pop” is required.

2. In =HYPGEOM.DIST, which is argument #3?

A. population_s ✓
B. cumulative
C. sample_s
D. criteria

Explanation: Argument #3 is “population_s”.

3. In =HYPGEOM.DIST, which is argument #2?

A. number_pop
B. criteria
C. number_sample ✓
D. range

Explanation: Argument #2 is “number_sample”.

4. Which use case fits =HYPGEOM.DIST?

A. Sort, Filter & Dedupe
B. Reporting
C. Date & Time Calculations
D. Probability & Hypothesis Testing ✓

Explanation: Use case “Probability & Hypothesis Testing” fits HYPGEOM.DIST.

5. What usually causes #VALUE! in =HYPGEOM.DIST?

A. Text is always ignored
B. مقادیر sample_s یا number_sample یا population_s یا number_pop خارج از محدوده مجاز هستند.
C. If any argument is nonnumeric, HYPGEOM.DIST returns the #VALUE! error value. ✓
D. Output is always a dynamic array

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

6. Which statement about =HYPGEOM.DIST is correct?

A. Output is always a dynamic array
B. All arguments are truncated to integers. ✓
C. Requires add-in
D. Select entire column for best performance

Explanation: Correct: All arguments are truncated to integers.

7. What is the fix for #VALUE! in =HYPGEOM.DIST?

A. Requires add-in
B. Output is always a dynamic array
C. برای همه آرگومان‌ها مقادیر عددی وارد کنید. ✓
D. Only works in old versions

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

8. Is argument “number_sample” required in =HYPGEOM.DIST?

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

Explanation: “number_sample” is required.

9. What is the fix for #NUM! in =HYPGEOM.DIST?

A. Volatile and recalculates every time
B. Correct the input value ✓
C. یکی از آرگومان‌ها غیرعددی است.
D. Select entire column for best performance

Explanation: If sample_s < 0 or sample_s is greater than the lesser of number_sample or population_s, HYPGEOM.DIST returns the #NUM! error value. If sample_s is less than the larger of 0 or (number_sample - number_population + population_s), HYPGEOM.DIST returns the #NUM! error value. If number_sample ≤ 0 or number_sample > number_population, HYPGEOM.DIST returns the #NUM! error value. If population_s ≤ 0 or population_s > number_population, HYPGEOM.DIST returns the #NUM! error value. If number_pop ≤ 0, HYPGEOM.DIST returns the #NUM! error value. — Fix: Correct the input value

10. What usually causes #NUM! in =HYPGEOM.DIST?

A. If sample_s < 0 or sample_s is greater than the lesser of number_sample or population_s, HYPGEOM.DIST returns the #NUM! error value. If sample_s is less than the larger of 0 or (number_sample - number_population + population_s), HYPGEOM.DIST returns the #NUM! error value. If number_sample ≤ 0 or number_sample > number_population, HYPGEOM.DIST returns the #NUM! error value. If population_s ≤ 0 or population_s > number_population, HYPGEOM.DIST returns the #NUM! error value. If number_pop ≤ 0, HYPGEOM.DIST returns the #NUM! error value. ✓
B. Requires add-in
C. یکی از آرگومان‌ها غیرعددی است.
D. Output is always a dynamic array