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

Quiz =ZTEST — 10 Questions

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

Question 1 of 10 1/10

Which use case fits =ZTEST?

Question 2 of 10 2/10

Which statement about =ZTEST is correct?

Question 3 of 10 3/10

Is argument “x” required in =ZTEST?

Question 4 of 10 4/10

Which function is NOT related to =ZTEST?

Question 5 of 10 5/10

Which function is related to =ZTEST?

Question 6 of 10 6/10

Does =ZTEST return a dynamic array?

Question 7 of 10 7/10

Is argument “sigma” required in =ZTEST?

Question 8 of 10 8/10

How many optional arguments does =ZTEST have?

Question 9 of 10 9/10

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

Question 10 of 10 10/10

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

Click a question to see the answer.

1. Which use case fits =ZTEST?

A. Investment Appraisal
B. Lookup & Retrieval
C. Reporting ✓
D. Loans & Installments

Explanation: Use case “Reporting” fits ZTEST.

2. Which statement about =ZTEST is correct?

A. Select entire column for best performance
B. Requires add-in
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. Text is always ignored

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. Is argument “x” required in =ZTEST?

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

Explanation: “x” is required.

4. Which function is NOT related to =ZTEST?

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

Explanation: “IFERROR” is not related to ZTEST.

5. Which function is related to =ZTEST?

A. CSCH
B. FORECAST ✓
C. REGEXTEST
D. CHISQ.INV

Explanation: “FORECAST” is related to ZTEST.

6. Does =ZTEST return a dynamic array?

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

Explanation: ZTEST does not spill.

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

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

Explanation: “sigma” is optional.

8. How many optional arguments does =ZTEST have?

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

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

9. What is the type of argument “x” in =ZTEST?

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

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

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

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

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