Compatibility =CHITEST(actual_range,expected_range)

Quiz =CHITEST — 15 Questions

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

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

← CHITEST ▦ Practice in Playground

Progress — 15 questions 1 of 15

Question 1 of 15 1/15

What is the output type of =CHITEST?

Question 2 of 15 2/15

Which formula is a valid example of =CHITEST?

Question 3 of 15 3/15

Which statement about =CHITEST is correct?

Question 4 of 15 4/15

Which use case fits =CHITEST?

Question 5 of 15 5/15

What is the fix for #N/A in =CHITEST?

Question 6 of 15 6/15

How many arguments does =CHITEST have in total?

Question 7 of 15 7/15

What usually causes #N/A in =CHITEST?

Question 8 of 15 8/15

Which is the correct syntax of =CHITEST?

Question 9 of 15 9/15

In =CHITEST, which is argument #1?

Question 10 of 15 10/15

Which function is related to =CHITEST?

Question 11 of 15 11/15

How many required arguments does =CHITEST have?

Question 12 of 15 12/15

What is the type of argument “actual_range” in =CHITEST?

Question 13 of 15 13/15

Since which Excel version is =CHITEST available?

Question 14 of 15 14/15

How many optional arguments does =CHITEST have?

Question 15 of 15 15/15

Is argument “actual_range” required in =CHITEST?

Click a question to see the answer.

1. What is the output type of =CHITEST?

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

Explanation: Output is “Number”.

2. Which formula is a valid example of =CHITEST?

A. CHITEST(A2:B4,A6:B8)
B. =CHITEST(A2:B4,A6:B8) ✓
C. =CHITEST(A2:B4,A6:B8, 0)
D. =FORECAST(A2:B4,A6:B8)

Explanation: Correct example: =CHITEST(A2:B4,A6:B8)

3. Which statement about =CHITEST is correct?

A. A low value of χ2 is an indicator of independence. As can be seen from the formula, χ2 is always positive or 0, and is 0 only if Aij = Eij for every i,j.
B. Select entire column for best performance
C. Volatile and recalculates every time
D. 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. ✓

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. Which use case fits =CHITEST?

A. Forecasting & Trends
B. Reporting ✓
C. Investment Appraisal
D. Numbering & Sample Data

Explanation: Use case “Reporting” fits CHITEST.

5. What is the fix for #N/A in =CHITEST?

A. Volatile and recalculates every time
B. Only works in old versions
C. مطمئن شوید هر دو محدوده هم‌اندازه‌اند و حداقل دو سطر یا دو ستون دارند. ✓
D. Text is always ignored

Explanation: If actual_range and expected_range have a different number of data points, CHITEST returns the #N/A error value. If r = 1 and c > 1, then df = c - 1 or if r > 1 and c = 1, then df = r - 1. r = c= 1 is not allowed and #N/A is returned. — Fix: مطمئن شوید هر دو محدوده هم‌اندازه‌اند و حداقل دو سطر یا دو ستون دارند.

6. How many arguments does =CHITEST have in total?

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

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

7. What usually causes #N/A in =CHITEST?

A. Volatile and recalculates every time
B. If actual_range and expected_range have a different number of data points, CHITEST returns the #N/A error value. If r = 1 and c > 1, then df = c - 1 or if r > 1 and c = 1, then df = r - 1. r = c= 1 is not allowed and #N/A is returned. ✓
C. Requires add-in
D. Text is always ignored

8. Which is the correct syntax of =CHITEST?

A. =FORECAST(actual_range,expected_range)
B. CHITEST(actual_range,expected_range)
C. =CHITEST(actual_range,expected_range) ✓
D. =CHITEST(actual_range,expected_range, 0)

Explanation: Correct syntax: =CHITEST(actual_range,expected_range)

9. In =CHITEST, which is argument #1?

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

Explanation: Argument #1 is “actual_range”.

10. Which function is related to =CHITEST?

A. DSUM
B. FORECAST ✓
C. NORM.DIST
D. ISNONTEXT

Explanation: “FORECAST” is related to CHITEST.

11. How many required arguments does =CHITEST have?

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

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

12. What is the type of argument “actual_range” in =CHITEST?

A. Value
B. Logical
C. Range ✓
D. Text

Explanation: Type of “actual_range” is “Range”.

13. Since which Excel version is =CHITEST available?

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

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

14. How many optional arguments does =CHITEST have?

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

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

15. Is argument “actual_range” required in =CHITEST?

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

Explanation: “actual_range” is required.