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.