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. Bar Chart
C. Pie 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 'Form Footer' section appears at:
A. Bottom of the report
B. Bottom of the form
C. Bottom of each page
D. Bottom of the screen

Correct Answer: Option B


Explanation:
Form Footer is at the bottom of the form.

This question belongs to: Computer Microsoft Office
Question #2
In PowerPoint, what does the 'Animation Painter' do?
A. Copies slide layout
B. Copies animation effects from one object to another
C. Applies animation to all slides
D. Creates a sequence of animations

Correct Answer: Option B


Explanation:
Animation Painter (similar to Format Painter) copies animation settings.

This question belongs to: Computer Microsoft Office
Question #3
In MS Access, to import data from another Access database, use:
A. Database Tools -> Import
B. Create -> Import Table
C. File -> Open
D. External Data -> Access

Correct Answer: Option D


Explanation:
External Data tab has import from Access.

This question belongs to: Computer Microsoft Office