Compatibility =WEIBULL(x,alpha,beta,cumulative)

Quiz =WEIBULL — 10 Questions

10 quiz questions about =WEIBULL — test syntax, arguments, examples & errors!

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

← WEIBULL ▦ Practice in Playground

Progress — 10 questions 1 of 10

Question 1 of 10 1/10

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

Question 2 of 10 2/10

Is argument “cumulative” required in =WEIBULL?

Question 3 of 10 3/10

Since which Excel version is =WEIBULL available?

Question 4 of 10 4/10

Is argument “x” required in =WEIBULL?

Question 5 of 10 5/10

How many optional arguments does =WEIBULL have?

Question 6 of 10 6/10

Which statement about =WEIBULL is correct?

Question 7 of 10 7/10

What usually causes #VALUE! in =WEIBULL?

Question 8 of 10 8/10

In =WEIBULL, which is argument #3?

Question 9 of 10 9/10

In =WEIBULL, which is argument #2?

Question 10 of 10 10/10

How many arguments does =WEIBULL have in total?

Click a question to see the answer.

1. What is the type of argument “alpha” in =WEIBULL?

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

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

2. Is argument “cumulative” required in =WEIBULL?

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

Explanation: “cumulative” is required.

3. Since which Excel version is =WEIBULL available?

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

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

4. Is argument “x” required in =WEIBULL?

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

Explanation: “x” is required.

5. How many optional arguments does =WEIBULL have?

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

Explanation: =WEIBULL has 4 required, 0 optional (4 total).

6. Which statement about =WEIBULL is correct?

A. Select entire column for best performance
B. Volatile and recalculates every time
C. Requires add-in
D. 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. For more information about the new function, see WEIBULL.DIST function. ✓

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. For more information about the new function, see WEIBULL.DIST function.

7. What usually causes #VALUE! in =WEIBULL?

A. مقدار x کوچک‌تر از صفر است یا alpha یا beta کوچک‌تر یا مساوی صفر هستند.
B. If x, alpha, or beta is nonnumeric, WEIBULL returns the #VALUE! error value. ✓
C. Output is always a dynamic array
D. Select entire column for best performance

Explanation: If x, alpha, or beta is nonnumeric, WEIBULL returns the #VALUE! error value. — Fix: برای x و alpha و beta مقادیر عددی وارد کنید و بررسی کنید سلول مرجع خالی یا متنی نباشد.

8. In =WEIBULL, which is argument #3?

A. lookup_value
B. cumulative
C. range
D. beta ✓

Explanation: Argument #3 is “beta”.

9. In =WEIBULL, which is argument #2?

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

Explanation: Argument #2 is “alpha”.

10. How many arguments does =WEIBULL have in total?

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

Explanation: =WEIBULL has 4 required, 0 optional (4 total).