Statistical =STEYX(known_y's, known_x's)

Quiz =STEYX — 15 Questions

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

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

← STEYX ▦ Practice in Playground

Progress — 15 questions 1 of 15

Question 1 of 15 1/15

Which statement about =STEYX is correct?

Question 2 of 15 2/15

Which use case fits =STEYX?

Question 3 of 15 3/15

What is the fix for #DIV/0! in =STEYX?

Question 4 of 15 4/15

What is the type of argument “known_x's” in =STEYX?

Question 5 of 15 5/15

What usually causes #DIV/0! in =STEYX?

Question 6 of 15 6/15

What is the type of argument “known_y's” in =STEYX?

Question 7 of 15 7/15

How many required arguments does =STEYX have?

Question 8 of 15 8/15

Is =STEYX volatile?

Question 9 of 15 9/15

Is argument “known_x's” required in =STEYX?

Question 10 of 15 10/15

How many optional arguments does =STEYX have?

Question 11 of 15 11/15

What usually causes #N/A in =STEYX?

Question 12 of 15 12/15

Since which Excel version is =STEYX available?

Question 13 of 15 13/15

Does =STEYX return a dynamic array?

Question 14 of 15 14/15

Is argument “known_y's” required in =STEYX?

Question 15 of 15 15/15

Which is the correct syntax of =STEYX?

Click a question to see the answer.

1. Which statement about =STEYX is correct?

A. Arguments can either be numbers or names, arrays, or references that contain numbers. ✓
B. Output is always a dynamic array
C. Logical values and text representations of numbers that you type directly into the list of arguments are counted.
D. If an array or reference argument contains text, logical values, or empty cells, those values are ignored; however, cells with the value zero are included.

Explanation: Correct: Arguments can either be numbers or names, arrays, or references that contain numbers.

2. Which use case fits =STEYX?

A. Forecasting & Trends ✓
B. Financial Calculations
C. External Data, Web & Cube
D. Advanced Formulas

Explanation: Use case “Forecasting & Trends” fits STEYX.

3. What is the fix for #DIV/0! in =STEYX?

A. Requires add-in
B. اگر known_y's و known_x's تعداد نقاط داده متفاوتی داشته باشند، تابع STEYX خطای #N/A را برمی‌گرداند.
C. حداقل سه جفت نقطه داده معتبر در هر دو محدوده وارد کنید و سلول‌های خالی را پر کنید. ✓
D. Volatile and recalculates every time

Explanation: If known_y's and known_x's are empty or have less than three data points, STEYX returns the #DIV/0! error value. — Fix: حداقل سه جفت نقطه داده معتبر در هر دو محدوده وارد کنید و سلول‌های خالی را پر کنید.

4. What is the type of argument “known_x's” in =STEYX?

A. Number
B. Range ✓
C. Reference
D. Value

Explanation: Type of “known_x's” is “Range”.

5. What usually causes #DIV/0! in =STEYX?

A. If known_y's and known_x's are empty or have less than three data points, STEYX returns the #DIV/0! error value. ✓
B. Requires add-in
C. Only works in old versions
D. Output is always a dynamic array

6. What is the type of argument “known_y's” in =STEYX?

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

Explanation: Type of “known_y's” is “Range”.

7. How many required arguments does =STEYX have?

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

Explanation: =STEYX has 2 required, 0 optional (2 total).

8. Is =STEYX volatile?

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

Explanation: STEYX is not volatile.

9. Is argument “known_x's” required in =STEYX?

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

Explanation: “known_x's” is required.

10. How many optional arguments does =STEYX have?

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

Explanation: =STEYX has 2 required, 0 optional (2 total).

11. What usually causes #N/A in =STEYX?

A. Requires add-in
B. Volatile and recalculates every time
C. If known_y's and known_x's have a different number of data points, STEYX returns the #N/A error value. ✓
D. Output is always a dynamic array

Explanation: If known_y's and known_x's have a different number of data points, STEYX returns the #N/A error value. — Fix: Make the two ranges the same size

12. Since which Excel version is =STEYX available?

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

Explanation: Version: “All versions”.

13. Does =STEYX return a dynamic array?

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

Explanation: STEYX does not spill.

14. Is argument “known_y's” required in =STEYX?

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

Explanation: “known_y's” is required.

15. Which is the correct syntax of =STEYX?

A. STEYX(known_y's, known_x's)
B. =FORECAST-LINEAR(known_y's, known_x's)
C. =STEYX(known_y's, known_x's, 0)
D. =STEYX(known_y's, known_x's) ✓

Explanation: Correct syntax: =STEYX(known_y's, known_x's)