Compatibility =FDIST(x,deg_freedom1,deg_freedom2)

Quiz =FDIST — 10 Questions

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

Question 1 of 10 1/10

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

Question 2 of 10 2/10

Does =FDIST return a dynamic array?

Question 3 of 10 3/10

Which formula is a valid example of =FDIST?

Question 4 of 10 4/10

Which is the correct syntax of =FDIST?

Question 5 of 10 5/10

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

Question 6 of 10 6/10

Is =FDIST volatile?

Question 7 of 10 7/10

Which statement about =FDIST is correct?

Question 8 of 10 8/10

What is the output type of =FDIST?

Question 9 of 10 9/10

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

Question 10 of 10 10/10

Since which Excel version is =FDIST available?

Click a question to see the answer.

1. What is the type of argument “deg_freedom2” in =FDIST?

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

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

2. Does =FDIST return a dynamic array?

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

Explanation: FDIST does not spill.

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

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

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

4. 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)

5. What is the type of argument “deg_freedom1” in =FDIST?

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

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

6. Is =FDIST volatile?

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

Explanation: FDIST is not volatile.

7. Which statement about =FDIST is correct?

A. If deg_freedom1 or deg_freedom2 is not an integer, it is truncated.
B. FDIST is calculated as FDIST=P( F>x ), where F is a random variable that has an F distribution with deg_freedom1 and deg_freedom2 degrees of freedom.
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.

8. What is the output type of =FDIST?

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

Explanation: Output is “Number”.

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

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

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

10. Since which Excel version is =FDIST available?

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

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