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

Which is the correct syntax of =ZTEST?

Question 3 of 15 3/15

In =ZTEST, which is argument #3?

Question 4 of 15 4/15

How many optional arguments does =ZTEST have?

Question 5 of 15 5/15

Which use case fits =ZTEST?

Question 6 of 15 6/15

What usually causes #N/A in =ZTEST?

Question 7 of 15 7/15

Since which Excel version is =ZTEST available?

Question 8 of 15 8/15

Which function is related to =ZTEST?

Question 9 of 15 9/15

Which function is NOT related to =ZTEST?

Question 10 of 15 10/15

Which statement about =ZTEST is correct?

Question 11 of 15 11/15

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

Question 12 of 15 12/15

Does =ZTEST return a dynamic array?

Question 13 of 15 13/15

In =ZTEST, which is argument #2?

Question 14 of 15 14/15

Is argument “x” required in =ZTEST?

Question 15 of 15 15/15

How many arguments does =ZTEST have in total?

Click a question to see the answer.

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

A. Mixed
B. Date
C. Text
D. Number ✓

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

2. Which is the correct syntax of =ZTEST?

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

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

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

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

Explanation: Argument #3 is “sigma”.

4. How many optional arguments does =ZTEST have?

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

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

5. Which use case fits =ZTEST?

A. Conditional Logic
B. Loans & Installments
C. Reporting ✓
D. Rounding & Numeric

Explanation: Use case “Reporting” fits ZTEST.

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

A. Only works in old versions
B. If array is empty, ZTEST returns the #N/A error value. ✓
C. Requires add-in
D. Output is always a dynamic array

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

7. Since which Excel version is =ZTEST available?

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

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

8. Which function is related to =ZTEST?

A. AMORLINC
B. FORECAST ✓
C. FREQUENCY
D. MAXIFS

Explanation: “FORECAST” is related to ZTEST.

9. Which function is NOT related to =ZTEST?

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

Explanation: “CUMIPMT” is not related to ZTEST.

10. Which statement about =ZTEST 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. Output is always a dynamic array
C. The following Excel formula can be used to calculate the two-tailed probability that the sample mean would be further from μ0 (in either direction) than AVERAGE(array), when the underlying population mean is μ0: =2 * MIN(ZTEST(array,μ0,sigma), 1 - ZTEST(array,μ0,sigma)).
D. 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.

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.

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

A. Text is always ignored
B. Requires add-in
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

12. Does =ZTEST return a dynamic array?

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

Explanation: ZTEST does not spill.

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

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

Explanation: Argument #2 is “x”.

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

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

Explanation: “x” is required.

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

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

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