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. Area Chart
C. Radar Chart
D. Line Chart
Answer: Option A
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.
In MS Excel, which of the following expressions is a valid syntax structure to calculate a logical conditional sum using multiple column criteria limits simultaneously?
Explanation:
The SUMIFS function evaluates multiple criteria fields. Its syntax differs from SUMIF because it places the 'Sum_Range' as the very first argument.
No comments yet. Be the first to start the discussion!