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

In =ZTEST, which is argument #1?

Question 2 of 15 2/15

Which function is related to =ZTEST?

Question 3 of 15 3/15

Which formula is a valid example of =ZTEST?

Question 4 of 15 4/15

Which use case fits =ZTEST?

Question 5 of 15 5/15

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

Question 6 of 15 6/15

Is =ZTEST volatile?

Question 7 of 15 7/15

Is argument “sigma” required in =ZTEST?

Question 8 of 15 8/15

Is argument “x” required in =ZTEST?

Question 9 of 15 9/15

Which function is NOT related to =ZTEST?

Question 10 of 15 10/15

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

Question 11 of 15 11/15

Which statement about =ZTEST is correct?

Question 12 of 15 12/15

Which category does =ZTEST belong to?

Question 13 of 15 13/15

In =ZTEST, which is argument #2?

Question 14 of 15 14/15

Is argument “array” 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. In =ZTEST, which is argument #1?

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

Explanation: Argument #1 is “array”.

2. Which function is related to =ZTEST?

A. FORECAST ✓
B. CEILING.PRECISE
C. DETECTLANGUAGE
D. EXP

Explanation: “FORECAST” is related to ZTEST.

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

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

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

4. Which use case fits =ZTEST?

A. Workdays & Due Dates
B. Reporting ✓
C. Sort, Filter & Dedupe
D. Error Handling

Explanation: Use case “Reporting” fits ZTEST.

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

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

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

6. Is =ZTEST volatile?

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

Explanation: ZTEST is not volatile.

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

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

Explanation: “sigma” is optional.

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

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

Explanation: “x” is required.

9. Which function is NOT related to =ZTEST?

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

Explanation: “NPER” is not related to ZTEST.

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

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

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

11. Which statement about =ZTEST is correct?

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

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.

12. Which category does =ZTEST belong to?

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

Explanation: Category is “Compatibility”.

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

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

Explanation: Argument #2 is “x”.

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

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

Explanation: “array” is required.

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

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

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