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

Quiz =SLOPE — 10 Questions

10 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 — 10 questions 1 of 10

Question 1 of 10 1/10

Which function is NOT related to =SLOPE?

Question 2 of 10 2/10

Since which Excel version is =SLOPE available?

Question 3 of 10 3/10

Does =SLOPE return a dynamic array?

Question 4 of 10 4/10

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

Question 5 of 10 5/10

What is the output type of =SLOPE?

Question 6 of 10 6/10

How many arguments does =SLOPE have in total?

Question 7 of 10 7/10

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

Question 8 of 10 8/10

Which formula is a valid example of =SLOPE?

Question 9 of 10 9/10

Which statement about =SLOPE is correct?

Question 10 of 10 10/10

In =SLOPE, which is argument #2?

Click a question to see the answer.

1. Which function is NOT related to =SLOPE?

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

Explanation: “REPT” is not related to SLOPE.

2. Since which Excel version is =SLOPE available?

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

Explanation: Version: “All versions”.

3. Does =SLOPE return a dynamic array?

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

Explanation: SLOPE does not spill.

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

A. 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. ✓
B. Volatile and recalculates every time
C. اگر known_y's و known_x's خالی باشند یا تعداد نقاط داده متفاوتی داشته باشند، تابع SLOPE خطای #N/A را برمی‌گرداند.
D. Select entire column for best performance

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 برای داده‌های هم‌خط استفاده کنید.

5. What is the output type of =SLOPE?

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

Explanation: Output is “Number”.

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

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

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

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

A. Output is always a dynamic array
B. Select entire column for best performance
C. Requires add-in
D. داده‌های ورودی را بررسی کنید که هم‌خط و نامعین نباشند؛ از تابع LINEST برای داده‌های هم‌خط استفاده کنید. ✓

8. Which formula is a valid example of =SLOPE?

A. =SLOPE(A3:A9,B3:B9) ✓
B. SLOPE(A3:A9,B3:B9)
C. =SLOPE(A3:A9,B3:B9, 0)
D. =INTERCEPT(A3:A9,B3:B9)

Explanation: Correct example: =SLOPE(A3:A9,B3:B9)

9. Which statement about =SLOPE is correct?

A. Select entire column for best performance
B. Text is always ignored
C. Volatile and recalculates every time
D. The arguments must be either numbers or names, arrays, or references that contain numbers. ✓

Explanation: Correct: The arguments must be either numbers or names, arrays, or references that contain numbers.

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

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

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