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 is the correct syntax of =FDIST?

Question 2 of 15 2/15

In =FDIST, which is argument #3?

Question 3 of 15 3/15

In =FDIST, which is argument #1?

Question 4 of 15 4/15

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

Question 5 of 15 5/15

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

Question 6 of 15 6/15

Which statement about =FDIST is correct?

Question 7 of 15 7/15

Which use case fits =FDIST?

Question 8 of 15 8/15

Does =FDIST return a dynamic array?

Question 9 of 15 9/15

Which function is related to =FDIST?

Question 10 of 15 10/15

Is argument “deg_freedom1” required in =FDIST?

Question 11 of 15 11/15

Is argument “deg_freedom2” required in =FDIST?

Question 12 of 15 12/15

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

Question 13 of 15 13/15

What is the output type of =FDIST?

Question 14 of 15 14/15

Which function is NOT related to =FDIST?

Question 15 of 15 15/15

How many optional arguments does =FDIST have?

Click a question to see the answer.

1. Which is the correct syntax of =FDIST?

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

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

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

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

Explanation: Argument #3 is “deg_freedom2”.

3. In =FDIST, which is argument #1?

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

Explanation: Argument #1 is “x”.

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

A. مقدار x منفی است یا درجه آزادی کوچک‌تر از ۱ یا بزرگ‌تر یا مساوی 10^10 است.
B. Text is always ignored
C. همه آرگومان‌ها را بررسی کنید و مقدار عددی وارد کنید. ✓
D. Select entire column for best performance

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

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

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

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

6. Which statement about =FDIST is correct?

A. Select entire column for best performance
B. Output is always a dynamic array
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. 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.

7. Which use case fits =FDIST?

A. External Data, Web & Cube
B. Reporting ✓
C. Reshape Tables
D. Numbering & Sample Data

Explanation: Use case “Reporting” fits FDIST.

8. Does =FDIST return a dynamic array?

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

Explanation: FDIST does not spill.

9. Which function is related to =FDIST?

A. FREQUENCY
B. TBILLYIELD
C. BITLSHIFT
D. FORECAST ✓

Explanation: “FORECAST” is related to FDIST.

10. Is argument “deg_freedom1” required in =FDIST?

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

Explanation: “deg_freedom1” is required.

11. Is argument “deg_freedom2” required in =FDIST?

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

Explanation: “deg_freedom2” is required.

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

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

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

13. What is the output type of =FDIST?

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

Explanation: Output is “Number”.

14. Which function is NOT related to =FDIST?

A. TBILLPRICE ✓
B. MODE
C. PERCENTILE
D. FORECAST

Explanation: “TBILLPRICE” is not related to FDIST.

15. How many optional arguments does =FDIST have?

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

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