Compatibility =CHIDIST(x,deg_freedom)

Quiz =CHIDIST — 10 Questions

10 quiz questions about =CHIDIST — test syntax, arguments, examples & errors!

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

← CHIDIST ▦ Practice in Playground

Progress — 10 questions 1 of 10

Question 1 of 10 1/10

How many arguments does =CHIDIST have in total?

Question 2 of 10 2/10

Which function is NOT related to =CHIDIST?

Question 3 of 10 3/10

In =CHIDIST, which is argument #2?

Question 4 of 10 4/10

Which statement about =CHIDIST is correct?

Question 5 of 10 5/10

Since which Excel version is =CHIDIST available?

Question 6 of 10 6/10

What is the type of argument “deg_freedom” in =CHIDIST?

Question 7 of 10 7/10

Does =CHIDIST return a dynamic array?

Question 8 of 10 8/10

Which category does =CHIDIST belong to?

Question 9 of 10 9/10

What usually causes #VALUE! in =CHIDIST?

Question 10 of 10 10/10

How many optional arguments does =CHIDIST have?

Click a question to see the answer.

1. How many arguments does =CHIDIST have in total?

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

Explanation: =CHIDIST has 2 required, 0 optional (2 total).

2. Which function is NOT related to =CHIDIST?

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

Explanation: “FACT” is not related to CHIDIST.

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

A. lookup_value
B. x
C. deg_freedom ✓
D. range

Explanation: Argument #2 is “deg_freedom”.

4. Which statement about =CHIDIST is correct?

A. CHIDIST is calculated as CHIDIST = P(X>x), where X is a χ2 random variable.
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. For more information about the new functions, see CHISQ.DIST function and CHISQ.DIST.RT function. ✓
C. Text is always ignored
D. Only works in old versions

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. For more information about the new functions, see CHISQ.DIST function and CHISQ.DIST.RT function.

5. Since which Excel version is =CHIDIST available?

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

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

6. What is the type of argument “deg_freedom” in =CHIDIST?

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

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

7. Does =CHIDIST return a dynamic array?

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

Explanation: CHIDIST does not spill.

8. Which category does =CHIDIST belong to?

A. Compatibility ✓
B. Math & Trig
C. Web
D. Database

Explanation: Category is “Compatibility”.

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

A. Select entire column for best performance
B. Requires add-in
C. If either argument is nonnumeric, CHIDIST returns the #VALUE! error value. ✓
D. Only works in old versions

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

10. How many optional arguments does =CHIDIST have?

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

Explanation: =CHIDIST has 2 required, 0 optional (2 total).