Compatibility =ZTEST(array,x,[sigma])

Quiz =ZTEST — 15 Questions

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

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

← ZTEST ▦ Practice in Playground

Progress — 15 questions 1 of 15

Question 1 of 15 1/15

Which category does =ZTEST belong to?

Question 2 of 15 2/15

Is argument “sigma” required in =ZTEST?

Question 3 of 15 3/15

Since which Excel version is =ZTEST available?

Question 4 of 15 4/15

Does =ZTEST return a dynamic array?

Question 5 of 15 5/15

In =ZTEST, which is argument #2?

Question 6 of 15 6/15

Is argument “array” required in =ZTEST?

Question 7 of 15 7/15

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

Question 8 of 15 8/15

How many arguments does =ZTEST have in total?

Question 9 of 15 9/15

Which function is NOT related to =ZTEST?

Question 10 of 15 10/15

Which use case fits =ZTEST?

Question 11 of 15 11/15

What usually causes #N/A in =ZTEST?

Question 12 of 15 12/15

Is argument “x” required in =ZTEST?

Question 13 of 15 13/15

What is the output type of =ZTEST?

Question 14 of 15 14/15

Which statement about =ZTEST is correct?

Question 15 of 15 15/15

In =ZTEST, which is argument #3?

Click a question to see the answer.

1. Which category does =ZTEST belong to?

A. Logical
B. Compatibility ✓
C. Date & Time
D. Cube

Explanation: Category is “Compatibility”.

2. Is argument “sigma” required in =ZTEST?

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

Explanation: “sigma” is optional.

3. Since which Excel version is =ZTEST available?

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

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

4. Does =ZTEST return a dynamic array?

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

Explanation: ZTEST does not spill.

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

A. criteria
B. value
C. array
D. x ✓

Explanation: Argument #2 is “x”.

6. Is argument “array” required in =ZTEST?

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

Explanation: “array” is required.

7. What is the fix for #N/A in =ZTEST?

A. Output is always a dynamic array
B. Only works in old versions
C. Enter a data range ✓
D. Select entire column for best performance

Explanation: If array is empty, ZTEST returns the #N/A error value. — Fix: Enter a data range

8. How many arguments does =ZTEST have in total?

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

Explanation: =ZTEST has 2 required, 1 optional (3 total).

9. Which function is NOT related to =ZTEST?

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

Explanation: “IMCOSH” is not related to ZTEST.

10. Which use case fits =ZTEST?

A. Sort, Filter & Dedupe
B. Reporting ✓
C. External Data, Web & Cube
D. Conditional Aggregation

Explanation: Use case “Reporting” fits ZTEST.

11. What usually causes #N/A in =ZTEST?

A. Output is always a dynamic array
B. Requires add-in
C. Volatile and recalculates every time
D. If array is empty, ZTEST returns the #N/A error value. ✓

Explanation: If array is empty, ZTEST returns the #N/A error value. — Fix: Enter a data range

12. Is argument “x” required in =ZTEST?

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

Explanation: “x” is required.

13. What is the output type of =ZTEST?

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

Explanation: Output is “Number”.

14. Which statement about =ZTEST is correct?

A. Volatile and recalculates every time
B. Select entire column for best performance
C. 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. ✓
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.

15. In =ZTEST, which is argument #3?

A. value
B. range
C. sigma ✓
D. array

Explanation: Argument #3 is “sigma”.