Compatibility =CONFIDENCE(alpha,standard_dev,size)

Quiz =CONFIDENCE — 15 Questions

15 quiz questions about =CONFIDENCE — test syntax, arguments, examples & errors!

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

← CONFIDENCE ▦ Practice in Playground

Progress — 15 questions 1 of 15

Question 1 of 15 1/15

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

Question 2 of 15 2/15

How many arguments does =CONFIDENCE have in total?

Question 3 of 15 3/15

What usually causes #VALUE! in =CONFIDENCE?

Question 4 of 15 4/15

Does =CONFIDENCE return a dynamic array?

Question 5 of 15 5/15

Which formula is a valid example of =CONFIDENCE?

Question 6 of 15 6/15

In =CONFIDENCE, which is argument #3?

Question 7 of 15 7/15

What usually causes #NUM! in =CONFIDENCE?

Question 8 of 15 8/15

Which is the correct syntax of =CONFIDENCE?

Question 9 of 15 9/15

How many optional arguments does =CONFIDENCE have?

Question 10 of 15 10/15

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

Question 11 of 15 11/15

Is argument “alpha” required in =CONFIDENCE?

Question 12 of 15 12/15

In =CONFIDENCE, which is argument #2?

Question 13 of 15 13/15

Which category does =CONFIDENCE belong to?

Question 14 of 15 14/15

Which statement about =CONFIDENCE is correct?

Question 15 of 15 15/15

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

Click a question to see the answer.

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

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

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

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

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

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

3. What usually causes #VALUE! in =CONFIDENCE?

A. Only works in old versions
B. Volatile and recalculates every time
C. If any argument is non-numeric, CONFIDENCE returns the #VALUE! error value. ✓
D. Requires add-in

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

4. Does =CONFIDENCE return a dynamic array?

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

Explanation: CONFIDENCE does not spill.

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

A. CONFIDENCE(A2,A3,A4)
B. =CONFIDENCE(A2,A3,A4, 0)
C. =FORECAST(A2,A3,A4)
D. =CONFIDENCE(A2,A3,A4) ✓

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

6. In =CONFIDENCE, which is argument #3?

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

Explanation: Argument #3 is “size”.

7. What usually causes #NUM! in =CONFIDENCE?

A. Requires add-in
B. Only works in old versions
C. If Alpha is ≤ 0 or ≥ 1, CONFIDENCE returns the #NUM! error value. If Standard_dev ≤ 0, CONFIDENCE returns the #NUM! error value. If Size < 1, CONFIDENCE returns the #NUM! error value. ✓
D. یکی از آرگومان‌ها غیرعددی است.

Explanation: If Alpha is ≤ 0 or ≥ 1, CONFIDENCE returns the #NUM! error value. If Standard_dev ≤ 0, CONFIDENCE returns the #NUM! error value. If Size < 1, CONFIDENCE returns the #NUM! error value. — Fix: Allowed values

8. Which is the correct syntax of =CONFIDENCE?

A. =FORECAST(alpha,standard_dev,size)
B. CONFIDENCE(alpha,standard_dev,size)
C. =CONFIDENCE(alpha,standard_dev,size, 0)
D. =CONFIDENCE(alpha,standard_dev,size) ✓

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

9. How many optional arguments does =CONFIDENCE have?

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

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

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

A. Select entire column for best performance
B. برای هر سه آرگومان مقدار عددی وارد کنید. ✓
C. Text is always ignored
D. Requires add-in

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

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

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

Explanation: “alpha” is required.

12. In =CONFIDENCE, which is argument #2?

A. size
B. standard_dev ✓
C. value
D. range

Explanation: Argument #2 is “standard_dev”.

13. Which category does =CONFIDENCE belong to?

A. Date & Time
B. Compatibility ✓
C. Logical
D. Math & Trig

Explanation: Category is “Compatibility”.

14. Which statement about =CONFIDENCE 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. Only works in old versions
C. Text is always ignored
D. Requires add-in

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.

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

A. Only works in old versions
B. Requires add-in
C. Allowed values ✓
D. Text is always ignored