Excel Charts Worksheet

What is the main benefit of using charts in Excel?

• To store data more securely

• To visually illustrate comparisons or trends in the data

• To limit the amount of data visible

• To make cell formatting more complex

Which of these is not a common Excel chart type mentioned in the GCFGlobal lesson?

• Column chart

• Pie chart

• Radar chart

• Line chart

If you want to change which data is shown on the horizontal (category) axis versus the vertical axis, which command do you use?

• Switch Row/Column

• Change Chart Type

• Add Chart Element

• Move Chart

To keep a chart automatically updated when new rows of data are added (below the current range), you should first:

• Format the data as a table

• Change the chart type to “area”

• Use the “Move Chart” command

• Insert more chart elements

Which chart type is best for showing the parts of a whole (percentages)?

• Line chart

• Column chart

• Pie chart

• Bar chart

6. The ________________ is the label that describes what the chart is showing.

• chart title

• legend

• axis label

• data series

The ________________ displays which data sets each color or marker in the chart represents.

• legend

• axis

• gridline

• title

8. The ________________ (or y-axis) shows the scale of values (e.g. amounts, counts) in many charts.

• vertical axis

• category axis

• legend

• gridline

The ________________ (or x-axis) shows the categories (e.g. months, product names).

• category axis

• vertical axis

• legend

• data series

The ________________ command allows you to swap which data appear across the axes.

• Switch Row/Column

• Transpose Data

• Sort Ascending

• Filter Data