Charting Latest - Charting Latest Assessment MODULE 2 Q & A 1. Wh...

DATA ANALYSIS

Advanced Graphing and Charting Latest Assessment

MODULE 2 Q & A

2024

• 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.

• 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.

• What is the advantage of using a pivot chart in Excel?

a) It allows you to create dynamic charts that can be

updated by changing the pivot table fields

b) It allows you to create interactive charts that can be

filtered, sorted, and sliced by using slicers and timelines

c) It allows you to create customized charts that can be

formatted and styled by using various options and tools

d) All of the above

*Answer: d) All of the above*

Rationale: A pivot chart is a type of chart that is linked to a

pivot table. It can be used to summarize and visualize large and complex data sets. It can be updated by changing the pivot table fields, filtered, sorted, and sliced by using slicers and timelines, and formatted and styled by using various options and tools.

Question 1:

Which of the following Excel chart types is most suitable for comparing the proportion of individual components to the whole, such as market share or budget allocation?

a) Line chart

b) Bar chart

c) Pie chart

d) Radar chart

Answer: c) Pie chart

Rationale: A pie chart is the most appropriate for

comparing the proportion of individual components to the

whole, making it ideal for displaying market share, budget allocation, or any other data that can be represented as parts of a whole.

Question 2:

What is the primary purpose of a scatter plot in Excel?

a) Showing the relationship between two variables

b) Comparing individual data points

c) Displaying trends over time

d) Representing part-to-whole relationships

Answer: a) Showing the relationship between two variables

Rationale: A scatter plot is used to display the relationship

between two variables, making it an effective tool for identifying correlations or patterns in the data.

Question 3:

When should a bubble chart be used in Excel?

a) To compare multiple data series over time

b) To display hierarchical data

c) To show the relationship between three variables

d) To represent values as percentages of the whole

Answer: c) To show the relationship between three

variables

Rationale: A bubble chart is suitable for visualizing the

relationship between three variables, with the size and color of the bubbles representing additional data dimensions.