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

What is the type of argument “sigma” in =ZTEST?

Question 2 of 15 2/15

Is argument “array” required in =ZTEST?

Question 3 of 15 3/15

In =ZTEST, which is argument #3?

Question 4 of 15 4/15

Which statement about =ZTEST is correct?

Question 5 of 15 5/15

Is argument “sigma” required in =ZTEST?

Question 6 of 15 6/15

In =ZTEST, which is argument #1?

Question 7 of 15 7/15

Which is the correct syntax of =ZTEST?

Question 8 of 15 8/15

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

Question 9 of 15 9/15

What usually causes #N/A in =ZTEST?

Question 10 of 15 10/15

In =ZTEST, which is argument #2?

Question 11 of 15 11/15

Which use case fits =ZTEST?

Question 12 of 15 12/15

Since which Excel version is =ZTEST available?

Question 13 of 15 13/15

How many required arguments does =ZTEST have?

Question 14 of 15 14/15

Which category does =ZTEST belong to?

Question 15 of 15 15/15

Which formula is a valid example of =ZTEST?

Click a question to see the answer.

1. What is the type of argument “sigma” in =ZTEST?

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

Explanation: Type of “sigma” is “Number”.

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

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

Explanation: “array” is required.

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

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

Explanation: Argument #3 is “sigma”.

4. Which statement about =ZTEST is correct?

A. ZTEST represents the probability that the sample mean would be greater than the observed value AVERAGE(array), when the underlying population mean is μ0. From the symmetry of the Normal distribution, if AVERAGE(array) < μ0, ZTEST will return a value greater than 0.5.
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. Select entire column for best performance
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. Is argument “sigma” required in =ZTEST?

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

Explanation: “sigma” is optional.

6. In =ZTEST, which is argument #1?

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

Explanation: Argument #1 is “array”.

7. Which is the correct syntax of =ZTEST?

A. =ZTEST(array,x,[sigma], 0)
B. =FORECAST(array,x,[sigma])
C. ZTEST(array,x,[sigma])
D. =ZTEST(array,x,[sigma]) ✓

Explanation: Correct syntax: =ZTEST(array,x,[sigma])

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

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

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

A. Volatile and recalculates every time
B. Only works in old versions
C. If array is empty, ZTEST returns the #N/A error value. ✓
D. Text is always ignored

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

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

A. array
B. range
C. x ✓
D. lookup_value

Explanation: Argument #2 is “x”.

11. Which use case fits =ZTEST?

A. Reporting ✓
B. Rounding & Numeric
C. Scientific & Unit Conversion
D. Workdays & Due Dates

Explanation: Use case “Reporting” fits ZTEST.

12. Since which Excel version is =ZTEST available?

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

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

13. How many required arguments does =ZTEST have?

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

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

14. Which category does =ZTEST belong to?

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

Explanation: Category is “Compatibility”.

15. Which formula is a valid example of =ZTEST?

A. =ZTEST(A2:A11,4) ✓
B. ZTEST(A2:A11,4)
C. =ZTEST(A2:A11,4, 0)
D. =FORECAST(A2:A11,4)

Explanation: Correct example: =ZTEST(A2:A11,4)