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

Since which Excel version is =FDIST available?

Question 3 of 10 3/10

Which statement about =FDIST is correct?

Question 4 of 10 4/10

In =FDIST, which is argument #3?

Question 5 of 10 5/10

What is the output type of =FDIST?

Question 6 of 10 6/10

What usually causes #NUM! in =FDIST?

Question 7 of 10 7/10

Which is the correct syntax of =FDIST?

Question 8 of 10 8/10

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

Question 9 of 10 9/10

What usually causes #VALUE! in =FDIST?

Question 10 of 10 10/10

How many arguments does =FDIST have in total?

Click a question to see the answer.

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

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

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

2. Since which Excel version is =FDIST available?

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

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

3. Which statement about =FDIST is correct?

A. 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.
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. Requires add-in
D. Select entire column for best performance

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 =FDIST, which is argument #3?

A. x
B. deg_freedom2 ✓
C. range
D. criteria

Explanation: Argument #3 is “deg_freedom2”.

5. What is the output type of =FDIST?

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

Explanation: Output is “Number”.

6. 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. Requires add-in
C. Select entire column for best performance
D. Output is always a dynamic array

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

7. Which is the correct syntax of =FDIST?

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

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

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

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

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

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

A. مقدار x منفی است یا درجه آزادی کوچک‌تر از ۱ یا بزرگ‌تر یا مساوی 10^10 است.
B. Volatile and recalculates every time
C. If any argument is nonnumeric, FDIST returns the #VALUE! error value. ✓
D. Only works in old versions

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

10. How many arguments does =FDIST have in total?

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

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