Excel Charting Quiz

Which feature in Excel turns data into a visual form?

• Gridlines

• Formula

• Chart

• Cell

Which part of a chart explains what each color or pattern stands for?

• Data label

• Axis

• Legend

• Title

What is the vertical line in a chart called?

• X-axis

• Y-axis

• Legend

• Title

What is the horizontal line in a chart called?

• X-axis

• Y-axis

• Legend

• Gridlines

What do you call the colored pieces in a pie chart?

• Slice

• Bar

• Dot

• Area

Which chart shows parts of a whole using a circle?

• Pie chart

• Column chart

• Line chart

• Bar chart

Which chart shows change over time with connected points?

• Pie chart

• Line chart

• Bar chart

• Radar chart

What is the shortcut to insert a chart in Excel quickly?

• F11

• Ctrl + C

• Alt + Enter

• Ctrl + V

Which chart uses rectangular bars in vertical direction?

• Bar chart

• Column chart

• Line chart

• Pie chart

Which chart uses bars that go sideways?

• Column chart

• Bar chart

• Pie chart

• Stock chart