1. What happens when you change the data in a worksheet associated with a chart?
   1. The chart is automatically updated.
   2. The chart is automatically deleted.
   3. The chart is grayed out.
   4. The chart is not linked to the worksheet data, so nothing happens.
2. Andrews column chart uses more than 100 sets of data and the columns are very small and hard to see. How can he adjust the chart to display only a few columns at a time?

1. Create separate charts for each category.
2. Change the data source to filter out a certain category.
3. Use the Chart Filters feature.
4. Change the chart type.