In Excel, which chart type is used to show the relationship between two variables? MCQ with Answer and Explanation

In Excel, which chart type is used to show the relationship between two variables?
A. Pie Chart
B. Scatter Chart
C. Line Chart
D. Bar Chart
Answer: Option B
Solution (By JKExamLibrary)
Scatter (or XY) charts show the relationship or correlation between two numeric variables. Line charts show trends, bar compare categories, pie proportions.

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
Which component of an MS Access window layout allows database administrators to define specific rules that prevent invalid entries before records are saved?
A. Format properties sheet
B. Default Value mapping
C. Input Mask editor
D. Validation Rule

Correct Answer: Option D


Explanation:
The Validation Rule property evaluates data entries against specified criteria constraints, blocking invalid inputs before they are saved to the database table.

This question belongs to: Computer Microsoft Office
Question #2 Report Error
To go to the previous page in a Word document, press:
A. Ctrl + Page Up
B. Ctrl + Up Arrow
C. Alt + Page Up
D. Page Up

Correct Answer: Option A


Explanation:
Ctrl+Page Up moves to the top of the previous page. Page Up scrolls up.

This question belongs to: Computer Microsoft Office
Question #3 Report Error
In MS PowerPoint, which option is used to add a background image to all slides?
A. Insert > Picture > Background
B. Design > Background Styles > Format Background
C. Both A and C
D. Format Background > Apply to All

Correct Answer: Option C


Explanation:
You can set a background picture via Format Background and then click 'Apply to All'. Also under Design > Background Styles > Format Background opens the same pane. So both A and C are correct. Thus answer D.

This question belongs to: Computer Microsoft Office