Compatibility =CHITEST(actual_range,expected_range)

Quiz =CHITEST — 10 Questions

10 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 — 10 questions 1 of 10

Question 1 of 10 1/10

Is argument “expected_range” required in =CHITEST?

Question 2 of 10 2/10

How many arguments does =CHITEST have in total?

Question 3 of 10 3/10

Which formula is a valid example of =CHITEST?

Question 4 of 10 4/10

Which statement about =CHITEST is correct?

Question 5 of 10 5/10

In =CHITEST, which is argument #2?

Question 6 of 10 6/10

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

Question 7 of 10 7/10

Which function is related to =CHITEST?

Question 8 of 10 8/10

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

Question 9 of 10 9/10

Which category does =CHITEST belong to?

Question 10 of 10 10/10

Does =CHITEST return a dynamic array?

Click a question to see the answer.

1. Is argument “expected_range” required in =CHITEST?

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

Explanation: “expected_range” is required.

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

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

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

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

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

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

4. Which statement about =CHITEST is correct?

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

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.

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

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

Explanation: Argument #2 is “expected_range”.

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

A. Select entire column for best performance
B. Output is always a dynamic array
C. Text is always ignored
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: مطمئن شوید هر دو محدوده هم‌اندازه‌اند و حداقل دو سطر یا دو ستون دارند.

7. Which function is related to =CHITEST?

A. FORECAST ✓
B. OCT2HEX
C. CODE
D. TREND

Explanation: “FORECAST” is related to CHITEST.

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

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

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

9. Which category does =CHITEST belong to?

A. Engineering
B. Compatibility ✓
C. Financial
D. Statistical

Explanation: Category is “Compatibility”.

10. Does =CHITEST return a dynamic array?

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

Explanation: CHITEST does not spill.