Which chart type in MS Excel tracks distinct coordinates across two separate numeric axes ($X$ and $Y$) to evaluate correlation patterns between two variable data structures? MCQ with Answer and Explanation

Which chart type in MS Excel tracks distinct coordinates across two separate numeric axes ($X$ and $Y$) to evaluate correlation patterns between two variable data structures?
A. Scatter (XY) Chart
B. Radar Chart
C. Area Chart
D. Line Chart
Answer: Option A
Solution (By JKExamLibrary)
A Scatter (XY) chart plots numeric values along horizontal ($X$) and vertical ($Y$) axes to visually expose mathematical relationships or scientific data correlations.

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 PowerPoint, to apply the same transition to all slides, click:
A. Animation Painter
B. Slide Master -> Transition
C. Copy transition and paste to all
D. Apply To All in the Transitions tab

Correct Answer: Option D


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

This question belongs to: Computer Microsoft Office
Question #2 Report Error
Which of the following is NOT a valid way to navigate between slides in PowerPoint during a slideshow?
A. Enter key
B. Spacebar
C. Tab key
D. Page Down

Correct Answer: Option C


Explanation:
During a slideshow, Spacebar, Enter, Page Down, and arrow keys (right/down) advance to the next slide. Tab key does not advance; it moves between hyperlinks or objects.

This question belongs to: Computer Microsoft Office
Question #3 Report Error
Which chart type is best suited to display trends over time in Excel?
A. Pie chart
B. Doughnut chart
C. Bar chart
D. Line chart

Correct Answer: Option D


Explanation:
Line charts are ideal for showing trends across a continuous period. Pie charts show parts of a whole.

This question belongs to: Computer Microsoft Office