CHART TYPES PURPOSES A. Column 1. Useful for showing trends in data B. Line 2. Compares parts of a whole C. Bar 3. Compares categorized data on a vertical axis 4. Compares categorized data on a horizontal axis Jse Chart Tools to Modify Charts 6. Felix created a chart but doesn't like how it displays his data. What advice would you give him? A. He must delete the chart and insert a new one from scratch. B. He can use the Change Chart Type tool to find a different chart. C. He should format the chart area to add different colors and borders. D. He can put the chart on another worksheet so no one sees it. 7. How can you simultaneously select the Quarter 2 data in each column of this chart? A. Right-click on any Quarter 2 block of data in any column. B. Triple-click on any Quarter 2 block of data in any column. C. Double-click on any Quarter 2 block of data in any column. D. Click once on any Quarter 2 block of data in any column. 8. Jade wants to add a background to her chart. Which of these is NOT a chart background option? A. Video B. Image C. Gradient D. Color E. Texture 9. Marcus' chart data looks very similar from column to column, since each amount shown is close to 15,000 . How can he fix this issue? A. There is no way to fix it; he'll have to adjust his data. B. His chart is too small; he can resize it to be bigger. C. He can adjust the minimum and maximum value displayed on the axis. D. He can increase the zoom on his spreadsheet to show more detail. Move and Size Charts 10. To move a chart, click anywhere in it and drag. A. True B. False 11. You cannot resize a chart after it's been moved to its own sheet. A. True B. False 12. Which image shows how a workbook would look if you moved a chart to its own sheet, using the default sheet tab name