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

Quiz =INTERCEPT — 10 Questions

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

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

← INTERCEPT ▦ Practice in Playground

Progress — 10 questions 1 of 10

Question 1 of 10 1/10

How many optional arguments does =INTERCEPT have?

Question 2 of 10 2/10

Does =INTERCEPT return a dynamic array?

Question 3 of 10 3/10

What is the fix for #N/A in =INTERCEPT?

Question 4 of 10 4/10

Which statement about =INTERCEPT is correct?

Question 5 of 10 5/10

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

Question 6 of 10 6/10

Is =INTERCEPT volatile?

Question 7 of 10 7/10

In =INTERCEPT, which is argument #2?

Question 8 of 10 8/10

What is the output type of =INTERCEPT?

Question 9 of 10 9/10

Which function is related to =INTERCEPT?

Question 10 of 10 10/10

Since which Excel version is =INTERCEPT available?

Click a question to see the answer.

1. How many optional arguments does =INTERCEPT have?

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

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

2. Does =INTERCEPT return a dynamic array?

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

Explanation: INTERCEPT does not spill.

3. What is the fix for #N/A in =INTERCEPT?

A. Make the two ranges the same size ✓
B. Volatile and recalculates every time
C. Text is always ignored
D. Only works in old versions

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

4. Which statement about =INTERCEPT is correct?

A. The arguments should be either numbers or names, arrays, or references that contain numbers. ✓
B. Volatile and recalculates every time
C. The equation for the intercept of the regression line, a, is: where the slope, b, is calculated as: and where x and y are the sample means AVERAGE(known_x's) and AVERAGE(known_y's).
D. Only works in old versions

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

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

A. Only works in old versions
B. Requires add-in
C. تعداد نقاط داده در known_y's و known_x's متفاوت است یا هیچ داده‌ای وجود ندارد.
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: INTERCEPT and SLOPE return a #DIV/0! error. ✓

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: INTERCEPT and SLOPE return a #DIV/0! error. — Fix: داده‌های ورودی را بررسی کنید تا پراکندگی کافی داشته باشند؛ در داده‌های هم‌خط می‌توانید از تابع LINEST استفاده کنید.

6. Is =INTERCEPT volatile?

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

Explanation: INTERCEPT is not volatile.

7. In =INTERCEPT, which is argument #2?

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

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

8. What is the output type of =INTERCEPT?

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

Explanation: Output is “Number”.

9. Which function is related to =INTERCEPT?

A. QUARTILE.INC
B. KURT
C. ACOS
D. SLOPE ✓

Explanation: “SLOPE” is related to INTERCEPT.

10. Since which Excel version is =INTERCEPT available?

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

Explanation: Version: “All versions”.