Excel Charting Quiz

What is a chart in Excel used for?

• To type long paragraphs

• To display data visually

• To format text

• To send emails

Which of the following is NOT a part of a chart?

• Legend

• Ribbon

• Title

• Axis

What does the X-axis usually represent?

• Categories

• Values

• Titles

• Numbers only

What does the Y-axis usually show?

• Categories

• Values

• Text

• Colors

Which chart type shows parts of a whole?

• Column

• Pie

• Line

• Bar

A column chart shows data using:

• Vertical bars

• Circles

• Lines

• Stars

A bar chart displays data using:

• Horizontal bars

• Vertical lines

• Dots

• Arrows

Line charts are best for showing:

• Circular data

• Trends over time

• Categories only

• Colors

What does a legend in a chart show?

• What each color or symbol means

• The title of the sheet

• The font size

• The number of pages

Which chart type shows rainfall over months with filled colors?

• Pie

• Area

• Line

• Bubble