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

Does =CHITEST return a dynamic array?

Question 2 of 15 2/15

Since which Excel version is =CHITEST available?

Question 3 of 15 3/15

Is =CHITEST volatile?

Question 4 of 15 4/15

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

Question 5 of 15 5/15

Is argument “actual_range” required in =CHITEST?

Question 6 of 15 6/15

Which formula is a valid example of =CHITEST?

Question 7 of 15 7/15

Which category does =CHITEST belong to?

Question 8 of 15 8/15

What usually causes #N/A in =CHITEST?

Question 9 of 15 9/15

What is the output type of =CHITEST?

Question 10 of 15 10/15

Which function is related to =CHITEST?

Question 11 of 15 11/15

Which statement about =CHITEST is correct?

Question 12 of 15 12/15

In =CHITEST, which is argument #1?

Question 13 of 15 13/15

In =CHITEST, which is argument #2?

Question 14 of 15 14/15

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

Question 15 of 15 15/15

How many required arguments does =CHITEST have?

Click a question to see the answer.

1. Does =CHITEST return a dynamic array?

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

Explanation: CHITEST does not spill.

2. Since which Excel version is =CHITEST available?

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

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

3. Is =CHITEST volatile?

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

Explanation: CHITEST is not volatile.

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

A. Output is always a dynamic array
B. Text is always ignored
C. Volatile and recalculates every time
D. مطمئن شوید هر دو محدوده هم‌اندازه‌اند و حداقل دو سطر یا دو ستون دارند. ✓

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: مطمئن شوید هر دو محدوده هم‌اندازه‌اند و حداقل دو سطر یا دو ستون دارند.

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

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

Explanation: “actual_range” is required.

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

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

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

7. Which category does =CHITEST belong to?

A. Compatibility ✓
B. Information
C. Web
D. Lookup & Reference

Explanation: Category is “Compatibility”.

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

A. Only works in old versions
B. Requires add-in
C. Output is always a dynamic array
D. 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. ✓

9. What is the output type of =CHITEST?

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

Explanation: Output is “Number”.

10. Which function is related to =CHITEST?

A. FORECAST ✓
B. COUPDAYBS
C. IMSUM
D. FORECAST.LINEAR

Explanation: “FORECAST” is related to CHITEST.

11. Which statement about =CHITEST is correct?

A. Only works in old versions
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. Output is always a dynamic array
D. Text is always ignored

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.

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

A. expected_range
B. actual_range ✓
C. lookup_value
D. criteria

Explanation: Argument #1 is “actual_range”.

13. In =CHITEST, which is argument #2?

A. lookup_value
B. value
C. criteria
D. expected_range ✓

Explanation: Argument #2 is “expected_range”.

14. What is the type of argument “expected_range” in =CHITEST?

A. Range ✓
B. Logical
C. Mixed
D. Reference

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

15. How many required arguments does =CHITEST have?

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

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