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

How many required arguments does =CONFIDENCE.NORM have?

Question 2 of 10 2/10

Which statement about =CONFIDENCE.NORM is correct?

Question 3 of 10 3/10

Which category does =CONFIDENCE.NORM belong to?

Question 4 of 10 4/10

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

Question 5 of 10 5/10

Does =CONFIDENCE.NORM return a dynamic array?

Question 6 of 10 6/10

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

Question 7 of 10 7/10

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

Question 8 of 10 8/10

What is the type of argument “standard_dev” in =CONFIDENCE.NORM?

Question 9 of 10 9/10

What is the type of argument “alpha” in =CONFIDENCE.NORM?

Question 10 of 10 10/10

Which function is NOT related to =CONFIDENCE.NORM?

Click a question to see the answer.

1. How many required arguments does =CONFIDENCE.NORM have?

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

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

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

A. If we assume alpha equals 0.05, we need to calculate the area under the standard normal curve that equals (1 - alpha), or 95 percent. This value is ± 1.96. The confidence interval is therefore:
B. If size is not an integer, it is truncated. ✓
C. Only works in old versions
D. Text is always ignored

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

3. Which category does =CONFIDENCE.NORM belong to?

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

Explanation: Category is “Statistical”.

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

A. standard_dev
B. range
C. lookup_value
D. alpha ✓

Explanation: Argument #1 is “alpha”.

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

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

Explanation: CONFIDENCE.NORM does not spill.

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

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

Explanation: “alpha” is required.

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

A. برای هر سه آرگومان مقدار عددی وارد کنید. ✓
B. Select entire column for best performance
C. Output is always a dynamic array
D. آلفا خارج از ‎۰ تا ۱، انحراف معیار صفر/منفی یا حجم نمونه کمتر از ‎۱ است.

Explanation: If any argument is nonnumeric, CONFIDENCE.NORM returns the #VALUE! error value. — Fix: برای هر سه آرگومان مقدار عددی وارد کنید.

8. What is the type of argument “standard_dev” in =CONFIDENCE.NORM?

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

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

9. What is the type of argument “alpha” in =CONFIDENCE.NORM?

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

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

10. Which function is NOT related to =CONFIDENCE.NORM?

A. NORM-S-INV
B. CONFIDENCE-T
C. STDEV-S
D. ERROR.TYPE ✓

Explanation: “ERROR.TYPE” is not related to CONFIDENCE.NORM.