.png){kind=logo}
1. What is the purpose of using a scatter plot in Excel?
a) To show the relationship between two variables
b) To show the distribution of one variable
c) To show the frequency of different categories
d) To show the trend of a variable over time
*Answer: a) To show the relationship between two
variables*
Rationale: A scatter plot is a type of chart that displays the
values of two variables as points on a Cartesian plane. It
can be used to explore the correlation, causation, or
clustering of the data.
2. What is the difference between a line chart and a
sparkline in Excel?
a) A line chart can display multiple series, while a
sparkline can only display one series
b) A line chart can have axes, labels, and legends, while a
sparkline does not have any of these elements
c) A line chart can be inserted as a separate object, while a
sparkline can be inserted into a cell
d) All of the above
*Answer: d) All of the above*
Rationale: A line chart is a type of chart that displays the
trend of a variable over time or across categories. It can
have multiple series, axes, labels, and legends to provide
more information and context. A sparkline is a mini-chart
that shows the variation of a single series in a cell. It does
not have any axes, labels, or legends to save space and
focus on the data.
.png)