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. Line Chart
B. Pie Chart
C. Bar Chart
D. Scatter Chart
Answer: Option D
Solution (By JKSSB Mock Tests)
Scatter (or XY) charts show the relationship or correlation between two numeric variables. Line charts show trends, bar compare categories, pie proportions.

Discuss this Question (0)

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

Practice More Microsoft Office Questions

Question #1
In MS Access, the 'Indexed' property set to 'Yes (No Duplicates)' creates:
A. An index allowing duplicates
B. A unique index, preventing duplicate values
C. A foreign key
D. A primary key

Correct Answer: Option B


Explanation:
No Duplicates enforces uniqueness.

This question belongs to: Computer Microsoft Office
Question #2
In PowerPoint, the 'Zoom slider' in the status bar is used to:
A. Set slide transition speed
B. Apply zoom animation
C. Zoom in on object during presentation
D. Adjust the magnification of the slide view

Correct Answer: Option D


Explanation:
Zoom slider changes view magnification.

This question belongs to: Computer Microsoft Office
Question #3
In PowerPoint, to apply the same transition to all slides, click:
A. Animation Painter
B. Apply To All in the Transitions tab
C. Slide Master -> Transition
D. Copy transition and paste to all

Correct Answer: Option B


Explanation:
Apply To All button sets the selected transition for every slide.

This question belongs to: Computer Microsoft Office