In Excel, which function is used to calculate the slope of a linear regression line? MCQ with Answer and Explanation

Question

Share Report Error

In Excel, which function is used to calculate the slope of a linear regression line?

A. SLOPE

B. LINEST

C. INTERCEPT

D. All of the above

Answer: Option D

Solution (By JKSSB Mock Tests)

SLOPE, INTERCEPT, and LINEST can all be used for linear regression analysis (LINEST returns array).

This question belongs to: Computer Microsoft Office

Request complete Subject PDF

Discuss this Question (0)

No comments yet. Be the first to start the discussion!

Practice More Microsoft Office Questions

Question #1

In PowerPoint, to add a table, go to:

A. Insert -> Table

B. Design -> Table

C. Home -> Table

D. View -> Table

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option A

Explanation:
Insert tab -> Table.

This question belongs to: Computer Microsoft Office

Question #2

What is the function of the shortcut key combination Ctrl + Spacebar when text is highlighted in MS Word?

A. Highlights the entire document page layout

B. Inserts a non-breaking space character

C. Applies double line spacing to the paragraph

D. Clears all manual character formatting from the selected text

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option D

Explanation:
Ctrl + Spacebar removes all manual character-level formatting (such as bold, italic, or custom font colors) from the selected text, resetting it to the default style.

This question belongs to: Computer Microsoft Office

Question #3

In PowerPoint, the keyboard shortcut to bring the selected object one step forward is:

A. Ctrl + Shift + F

B. Ctrl + ]

C. Alt + F

D. Ctrl + F

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option A

Explanation:
Ctrl+Shift+F brings object forward (bring forward). Ctrl+Shift+B sends backward.

This question belongs to: Computer Microsoft Office

Explore All Microsoft Office MCQs