Statistical =CONFIDENCE.NORM(alpha,standard_dev,size)

Quiz =CONFIDENCE.NORM — 10 Questions

10 quiz questions about =CONFIDENCE.NORM — test syntax, arguments, examples & errors!

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

← CONFIDENCE.NORM ▦ Practice in Playground

Progress — 10 questions 1 of 10

Question 1 of 10 1/10

Since which Excel version is =CONFIDENCE.NORM available?

Question 2 of 10 2/10

In =CONFIDENCE.NORM, which is argument #1?

Question 3 of 10 3/10

Which statement about =CONFIDENCE.NORM is correct?

Question 4 of 10 4/10

What is the fix for #NUM! in =CONFIDENCE.NORM?

Question 5 of 10 5/10

What is the output type of =CONFIDENCE.NORM?

Question 6 of 10 6/10

Does =CONFIDENCE.NORM return a dynamic array?

Question 7 of 10 7/10

How many arguments does =CONFIDENCE.NORM have in total?

Question 8 of 10 8/10

Is argument “alpha” required in =CONFIDENCE.NORM?

Question 9 of 10 9/10

Which formula is a valid example of =CONFIDENCE.NORM?

Question 10 of 10 10/10

Which is the correct syntax of =CONFIDENCE.NORM?

Click a question to see the answer.

1. Since which Excel version is =CONFIDENCE.NORM available?

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

Explanation: Version: “Excel 2010”.

2. In =CONFIDENCE.NORM, which is argument #1?

A. value
B. lookup_value
C. criteria
D. alpha ✓

Explanation: Argument #1 is “alpha”.

3. Which statement about =CONFIDENCE.NORM is correct?

A. Requires add-in
B. Only works in old versions
C. If size is not an integer, it is truncated. ✓
D. Text is always ignored

Explanation: Correct: If size is not an integer, it is truncated.

4. What is the fix for #NUM! in =CONFIDENCE.NORM?

A. Volatile and recalculates every time
B. یکی از آرگومان‌ها غیرعددی است.
C. Correct the input value ✓
D. Requires add-in

Explanation: If alpha ≤ 0 or alpha ≥ 1, CONFIDENCE.NORM returns the #NUM! error value. If standard_dev ≤ 0, CONFIDENCE.NORM returns the #NUM! error value. If size < 1, CONFIDENCE.NORM returns the #NUM! error value. — Fix: Correct the input value

5. What is the output type of =CONFIDENCE.NORM?

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

Explanation: Output is “Number”.

6. Does =CONFIDENCE.NORM return a dynamic array?

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

Explanation: CONFIDENCE.NORM does not spill.

7. How many arguments does =CONFIDENCE.NORM have in total?

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

Explanation: =CONFIDENCE.NORM has 3 required, 0 optional (3 total).

8. Is argument “alpha” required in =CONFIDENCE.NORM?

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

Explanation: “alpha” is required.

9. Which formula is a valid example of =CONFIDENCE.NORM?

A. =STDEV-S(A2,A3,A4)
B. =CONFIDENCE.NORM(A2,A3,A4, 0)
C. =CONFIDENCE.NORM(A2,A3,A4) ✓
D. CONFIDENCE.NORM(A2,A3,A4)

Explanation: Correct example: =CONFIDENCE.NORM(A2,A3,A4)

10. Which is the correct syntax of =CONFIDENCE.NORM?

A. CONFIDENCE.NORM(alpha,standard_dev,size)
B. =STDEV-S(alpha,standard_dev,size)
C. =CONFIDENCE.NORM(alpha,standard_dev,size) ✓
D. =CONFIDENCE.NORM(alpha,standard_dev,size, 0)

Explanation: Correct syntax: =CONFIDENCE.NORM(alpha,standard_dev,size)