Excel Charts

What is the primary purpose of a Pie Chart in Excel?

• Displaying trends over time

• Showing data changes over a period

• Illustrating comparisons among items

• Displaying the contribution of each value to a total

In Column charts in Excel, how are categories typically organized?

• Along the vertical axis

• Along the diagonal axis

• Along the horizontal axis

• Along both horizontal and vertical axes

When is a Line Chart in Excel most suitable?

• Displaying trends over time

• Showing data changes over a period

• Illustrating comparisons among items

• Displaying the contribution of each value to a total

What is a Combination Chart in Excel?

• a) A chart that combines text labels and numeric labels
• b) A chart that combines two or more chart types in a single chart
• c) A chart that combines categories and values on both axes
• d) A chart that combines pie and bar charts

How is an Area Chart different from a Line Chart in Excel?

• It has more colorful lines

• It displays trends over time

• It has areas below the lines filled with colours

• It is used for illustrating comparisons among items

What is a Pivot Chart in Excel?

• A chart displaying only pivot tables

• A chart showing data changes over time

• The visual representation of a pivot table

• A chart with combined data series

What does a Stacked Column Chart in Excel display?

• Trends over time

• Data changes over a period

• Contribution of each value to a total

• Comparisons among items

Which type of chart is best suited for displaying trends over time with text labels or dates?

• Pie Chart

• Column Chart

• Line Chart

• Stacked Column Chart

What does an Area Chart with filled colors below the lines represent in Excel?

• Data changes over a period

• Trends over time

• Contribution of each value to a total

• Comparisons among items

How are Pivot Charts and Pivot Tables connected in Excel?

• They share the same color palette

• They are both used for displaying trends

• Pivot charts and pivot tables are not connected

• They are the visual and data representations of the same data.