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

Question Report Error

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

A. INTERCEPT

B. All of the above

C. SLOPE

D. LINEST

Answer: Option B

Solution (By JKExamLibrary)

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

This question belongs to: Computer Microsoft Office

Discuss this Question (0)

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

Practice More Microsoft Office Questions

Question #1 Report Error

In MS Word, the 'Ctrl + Alt + F' shortcut inserts:

A. A page number

B. A hyperlink

C. A footnote

D. An endnote

View Answer & Solution Discuss

Correct Answer: Option C

Explanation:
Ctrl+Alt+F inserts a footnote. Ctrl+Alt+D inserts endnote.

This question belongs to: Computer Microsoft Office

Question #2 Report Error

To quickly summon the 'Save As' dialog box in MS Office, press:

A. Shift + F12

B. Alt + F2

C. Ctrl + S

D. F12

View Answer & Solution Discuss

Correct Answer: Option D

Explanation:
F12 opens Save As. Ctrl + S saves the file (or Save As if never saved). Shift + F12 also saves (same as Ctrl+S). Alt+F2 opens Save As in some versions, but F12 is standard.

This question belongs to: Computer Microsoft Office

Question #3 Report Error

Which data type field property option in MS Access lets you create a drop-down choice list that pulls options either from an existing table source or a hardcoded value set?

A. Calculated Field choice

B. Hyperlink Field Type

C. Lookup Wizard

D. Attachment properties

View Answer & Solution Discuss

Correct Answer: Option C

Explanation:
The Lookup Wizard establishes a lookup field that displays a clean dropdown list of choices derived dynamically from another database table reference or static list parameter.

This question belongs to: Computer Microsoft Office

Explore All Microsoft Office MCQs