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 usually causes #VALUE! in =CONFIDENCE?

Question 2 of 15 2/15

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

Question 3 of 15 3/15

Which statement about =CONFIDENCE is correct?

Question 4 of 15 4/15

Which function is related to =CONFIDENCE?

Question 5 of 15 5/15

Which category does =CONFIDENCE belong to?

Question 6 of 15 6/15

Since which Excel version is =CONFIDENCE available?

Question 7 of 15 7/15

Which function is NOT related to =CONFIDENCE?

Question 8 of 15 8/15

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

Question 9 of 15 9/15

In =CONFIDENCE, which is argument #1?

Question 10 of 15 10/15

Is =CONFIDENCE volatile?

Question 11 of 15 11/15

Which use case fits =CONFIDENCE?

Question 12 of 15 12/15

What is the output type of =CONFIDENCE?

Question 13 of 15 13/15

How many arguments does =CONFIDENCE have in total?

Question 14 of 15 14/15

In =CONFIDENCE, which is argument #2?

Question 15 of 15 15/15

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

Click a question to see the answer.

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

A. If any argument is non-numeric, CONFIDENCE returns the #VALUE! error value. ✓
B. Only works in old versions
C. Output is always a dynamic array
D. آلفا خارج از ‎۰ تا ۱، انحراف معیار صفر/منفی یا حجم نمونه کمتر از ‎۱ است.

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

2. What is the type of argument “size” in =CONFIDENCE?

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

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

3. 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. Select entire column for best performance
C. Output is always a dynamic array
D. Only works in old versions

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.

4. Which function is related to =CONFIDENCE?

A. MEDIAN
B. AND
C. FORECAST ✓
D. FORECAST.ETS.SEASONALITY

Explanation: “FORECAST” is related to CONFIDENCE.

5. Which category does =CONFIDENCE belong to?

A. Logical
B. Math & Trig
C. Text
D. Compatibility ✓

Explanation: Category is “Compatibility”.

6. Since which Excel version is =CONFIDENCE available?

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

Explanation: Version: “Excel 2007 (Compatibility)”.

7. Which function is NOT related to =CONFIDENCE?

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

Explanation: “NUMBERVALUE” is not related to CONFIDENCE.

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

A. یکی از آرگومان‌ها غیرعددی است.
B. Volatile and recalculates every time
C. Allowed values ✓
D. Select entire column for best performance

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

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

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

Explanation: Argument #1 is “alpha”.

10. Is =CONFIDENCE volatile?

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

Explanation: CONFIDENCE is not volatile.

11. Which use case fits =CONFIDENCE?

A. External Data, Web & Cube
B. Reporting ✓
C. Scientific & Unit Conversion
D. Investment Appraisal

Explanation: Use case “Reporting” fits CONFIDENCE.

12. What is the output type of =CONFIDENCE?

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

Explanation: Output is “Number”.

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

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

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

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

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

Explanation: Argument #2 is “standard_dev”.

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

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

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