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. Radar Chart
B. Scatter (XY) Chart
C. Area Chart
D. Line Chart
Answer: Option B
Solution (By JKSSB Mock Tests)
A Scatter (XY) chart plots numeric values along horizontal ($X$) and vertical ($Y$) axes to visually expose mathematical relationships or scientific data correlations.

Discuss this Question (0)

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

Practice More Microsoft Office Questions

Question #1
Which option under the MS PowerPoint Slide Show tab allows a presenter to configure presentation screens to run continuously in an automated loop at a public kiosk?
A. Set Up Slide Show
B. Rehearse Timings tool
C. Custom Slide Show
D. Presenter View properties

Correct Answer: Option A


Explanation:
The 'Set Up Slide Show' dialog box contains configuration options to set the presentation type to 'Browsed at a kiosk (full screen)', which runs the slide show in a continuous loop until Esc is pressed.

This question belongs to: Computer Microsoft Office
Question #2
What is the function of the 'F2' key in MS Excel?
A. Opens the Print dialog
B. Selects the entire column
C. Edits the active cell, placing cursor at the end
D. Saves the workbook

Correct Answer: Option C


Explanation:
F2 allows editing directly in a cell. Ctrl+Space selects column.

This question belongs to: Computer Microsoft Office
Question #3
In Excel, which function is used to calculate the sum of a range with criteria?
A. SUMPRODUCT
B. All of the above
C. SUMIFS
D. SUMIF

Correct Answer: Option B


Explanation:
SUMIF, SUMIFS, and SUMPRODUCT can all perform conditional sums (SUMPRODUCT can do multiple criteria). So all are valid.

This question belongs to: Computer Microsoft Office