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

Which formula is a valid example of =CHITEST?

Question 2 of 10 2/10

Which statement about =CHITEST is correct?

Question 3 of 10 3/10

In =CHITEST, which is argument #1?

Question 4 of 10 4/10

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

Question 5 of 10 5/10

Which is the correct syntax of =CHITEST?

Question 6 of 10 6/10

What usually causes #N/A in =CHITEST?

Question 7 of 10 7/10

Which category does =CHITEST belong to?

Question 8 of 10 8/10

What is the output type of =CHITEST?

Question 9 of 10 9/10

How many arguments does =CHITEST have in total?

Question 10 of 10 10/10

Is argument “actual_range” required in =CHITEST?

Click a question to see the answer.

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

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

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

2. Which statement about =CHITEST is correct?

A. Requires add-in
B. Volatile and recalculates every time
C. Text is always ignored
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.

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

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

Explanation: Argument #1 is “actual_range”.

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

A. Array
B. Range ✓
C. Date
D. Text

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

5. Which is the correct syntax of =CHITEST?

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

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

6. 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. Select entire column for best performance
D. Requires add-in

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 category does =CHITEST belong to?

A. Math & Trig
B. Financial
C. Compatibility ✓
D. Text

Explanation: Category is “Compatibility”.

8. What is the output type of =CHITEST?

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

Explanation: Output is “Number”.

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

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

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

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

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

Explanation: “actual_range” is required.