Quiz - Lesson 5

What is a chart in Microsoft Excel?

• A type of formula

• A visual representation of worksheet data

• A formatting tool

• A data entry method

Which chart type is best for comparing values across categories using vertical bars?

• Bar

• Line

• Column

• Pie

A Pie chart is most useful when:

• Values are negative

• Data represents trends over time

• You have multiple data series

• Values add up to a total

Which chart type is used to display trends over time?

• Line

• Scatter

• Column

• Bar

The Scatter chart is best for:

• Comparing multiple values

• Showing the correlation between two data series

• Displaying cumulative data

• Representing hierarchical relationships

Which chart type emphasizes differences between multiple sets of data over time?

• Pie

• Radar

• Area

• Surface

A Sunburst chart represents data using:

• A single line

• Multiple rings with segment values

• Bars and columns

• X and Y axes

Which chart type requires four series of values in the order: Open-High-Low-Close?

• Stock

• Scatter

• Surface

• Radar

What is the main purpose of Sparklines in Excel?

• To create a large chart

• To summarize data in a compact visual format

• To create hyperlinks

• To replace formulas

Which of the following is NOT a type of Sparkline?

• Line

• Column

• Pie

• Win/Loss