Compatibility =FDIST(x,deg_freedom1,deg_freedom2)

Quiz =FDIST — 15 Questions

15 quiz questions about =FDIST — test syntax, arguments, examples & errors!

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

← FDIST ▦ Practice in Playground

Progress — 15 questions 1 of 15

Question 1 of 15 1/15

Which function is related to =FDIST?

Question 2 of 15 2/15

Does =FDIST return a dynamic array?

Question 3 of 15 3/15

Is argument “x” required in =FDIST?

Question 4 of 15 4/15

Which statement about =FDIST is correct?

Question 5 of 15 5/15

Which formula is a valid example of =FDIST?

Question 6 of 15 6/15

How many required arguments does =FDIST have?

Question 7 of 15 7/15

What usually causes #NUM! in =FDIST?

Question 8 of 15 8/15

In =FDIST, which is argument #2?

Question 9 of 15 9/15

What is the type of argument “x” in =FDIST?

Question 10 of 15 10/15

What is the fix for #VALUE! in =FDIST?

Question 11 of 15 11/15

What usually causes #VALUE! in =FDIST?

Question 12 of 15 12/15

Which is the correct syntax of =FDIST?

Question 13 of 15 13/15

Is =FDIST volatile?

Question 14 of 15 14/15

Which use case fits =FDIST?

Question 15 of 15 15/15

What is the output type of =FDIST?

Click a question to see the answer.

1. Which function is related to =FDIST?

A. FORECAST ✓
B. FVSCHEDULE
C. GROWTH
D. CHISQ.DIST.RT

Explanation: “FORECAST” is related to FDIST.

2. Does =FDIST return a dynamic array?

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

Explanation: FDIST does not spill.

3. Is argument “x” required in =FDIST?

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

Explanation: “x” is required.

4. Which statement about =FDIST is correct?

A. If deg_freedom1 or deg_freedom2 is not an integer, it is truncated.
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. ✓
C. Only works in old versions
D. Volatile and recalculates every time

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.

5. Which formula is a valid example of =FDIST?

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

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

6. How many required arguments does =FDIST have?

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

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

7. What usually causes #NUM! in =FDIST?

A. If x is negative, FDIST returns the #NUM! error value. If deg_freedom1 < 1 or deg_freedom1 ≥ 10^10, FDIST returns the #NUM! error value. If deg_freedom2 < 1 or deg_freedom2 ≥ 10^10, FDIST returns the #NUM! error value. ✓
B. Only works in old versions
C. Select entire column for best performance
D. Requires add-in

Explanation: If x is negative, FDIST returns the #NUM! error value. If deg_freedom1 < 1 or deg_freedom1 ≥ 10^10, FDIST returns the #NUM! error value. If deg_freedom2 < 1 or deg_freedom2 ≥ 10^10, FDIST returns the #NUM! error value. — Fix: Allowed values

8. In =FDIST, which is argument #2?

A. range
B. value
C. lookup_value
D. deg_freedom1 ✓

Explanation: Argument #2 is “deg_freedom1”.

9. What is the type of argument “x” in =FDIST?

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

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

10. What is the fix for #VALUE! in =FDIST?

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

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

11. What usually causes #VALUE! in =FDIST?

A. Only works in old versions
B. Select entire column for best performance
C. If any argument is nonnumeric, FDIST returns the #VALUE! error value. ✓
D. Text is always ignored

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

12. Which is the correct syntax of =FDIST?

A. =FDIST(x,deg_freedom1,deg_freedom2) ✓
B. =FORECAST(x,deg_freedom1,deg_freedom2)
C. FDIST(x,deg_freedom1,deg_freedom2)
D. =FDIST(x,deg_freedom1,deg_freedom2, 0)

Explanation: Correct syntax: =FDIST(x,deg_freedom1,deg_freedom2)

13. Is =FDIST volatile?

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

Explanation: FDIST is not volatile.

14. Which use case fits =FDIST?

A. Conditional Aggregation
B. Worksheet Info & Navigation
C. Error Handling
D. Reporting ✓

Explanation: Use case “Reporting” fits FDIST.

15. What is the output type of =FDIST?

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

Explanation: Output is “Number”.