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

Quiz =SLOPE — 15 Questions

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

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

← SLOPE ▦ Practice in Playground

Progress — 15 questions 1 of 15

Question 1 of 15 1/15

Since which Excel version is =SLOPE available?

Question 2 of 15 2/15

How many optional arguments does =SLOPE have?

Question 3 of 15 3/15

Which function is related to =SLOPE?

Question 4 of 15 4/15

What usually causes #N/A in =SLOPE?

Question 5 of 15 5/15

How many arguments does =SLOPE have in total?

Question 6 of 15 6/15

Which function is NOT related to =SLOPE?

Question 7 of 15 7/15

What is the output type of =SLOPE?

Question 8 of 15 8/15

Does =SLOPE return a dynamic array?

Question 9 of 15 9/15

Which is the correct syntax of =SLOPE?

Question 10 of 15 10/15

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

Question 11 of 15 11/15

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

Question 12 of 15 12/15

Which category does =SLOPE belong to?

Question 13 of 15 13/15

In =SLOPE, which is argument #2?

Question 14 of 15 14/15

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

Question 15 of 15 15/15

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

Click a question to see the answer.

1. Since which Excel version is =SLOPE available?

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

Explanation: Version: “All versions”.

2. How many optional arguments does =SLOPE have?

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

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

3. Which function is related to =SLOPE?

A. ADDRESS
B. PRICEDISC
C. PROPER
D. INTERCEPT ✓

Explanation: “INTERCEPT” is related to SLOPE.

4. What usually causes #N/A in =SLOPE?

A. Select entire column for best performance
B. If known_y's and known_x's are empty or have a different number of data points, SLOPE returns the #N/A error value. ✓
C. Output is always a dynamic array
D. Only works in old versions

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

5. How many arguments does =SLOPE have in total?

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

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

6. Which function is NOT related to =SLOPE?

A. FORECAST-LINEAR
B. MDURATION ✓
C. INTERCEPT
D. RSQ

Explanation: “MDURATION” is not related to SLOPE.

7. What is the output type of =SLOPE?

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

Explanation: Output is “Number”.

8. Does =SLOPE return a dynamic array?

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

Explanation: SLOPE does not spill.

9. Which is the correct syntax of =SLOPE?

A. =SLOPE(known_y's, known_x's) ✓
B. SLOPE(known_y's, known_x's)
C. =INTERCEPT(known_y's, known_x's)
D. =SLOPE(known_y's, known_x's, 0)

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

10. What is the fix for #DIV/0! in =SLOPE?

A. اگر known_y's و known_x's خالی باشند یا تعداد نقاط داده متفاوتی داشته باشند، تابع SLOPE خطای #N/A را برمی‌گرداند.
B. Requires add-in
C. داده‌های ورودی را بررسی کنید که هم‌خط و نامعین نباشند؛ از تابع LINEST برای داده‌های هم‌خط استفاده کنید. ✓
D. Only works in old versions

Explanation: For example, if the data points of the known_y's argument are 0 and the data points of the known_x's argument are 1: SLOPE and INTERCEPT return a #DIV/0! error. — Fix: داده‌های ورودی را بررسی کنید که هم‌خط و نامعین نباشند؛ از تابع LINEST برای داده‌های هم‌خط استفاده کنید.

11. What usually causes #DIV/0! in =SLOPE?

A. Only works in old versions
B. Text is always ignored
C. Output is always a dynamic array
D. For example, if the data points of the known_y's argument are 0 and the data points of the known_x's argument are 1: SLOPE and INTERCEPT return a #DIV/0! error. ✓

12. Which category does =SLOPE belong to?

A. Date & Time
B. Web
C. Statistical ✓
D. Cube

Explanation: Category is “Statistical”.

13. In =SLOPE, which is argument #2?

A. known_y's
B. known_x's ✓
C. value
D. lookup_value

Explanation: Argument #2 is “known_x's”.

14. Is argument “known_x's” required in =SLOPE?

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

Explanation: “known_x's” is required.

15. What is the type of argument “known_x's” in =SLOPE?

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

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