Workbook, Worksheets, and Charts

1. You want to chart the average summer time temperatures of the 20 hottest cities in the United States. Which type of chart would be best for this purpose? 

• Bar 
• Column 
• Line 
• Pie 

2. Which direction does the Y-Axis run?

• Horizontal
• Vertical
• Diagonal

3. You want to compare the shooting percentage of the five starters on the basketball team. Which type of chart would be best for this purpose? 

• Pie 
• Line 
• Column/Bar
• Flow 

4. You have been tracking your home expenses. You want to see what percentage each category represents. Which type of chart would be best for this purpose?

• Bar 
• Column 
• Line 
• Pie 

5. If you want to combine cells, use the _____ command

• join
• add
• merge
• you can't do that!

6. What type of chart best shows how data changes over time? 

• Line 
• Bar 
• Pie 
• Column 

7. Each workbook file can only have 2 worksheets...

• True
• False 

8. Which keys would you press to copy worksheet data in the clipboard? 

• Ctrl-V 
• Ctrl-P 
• Ctrl-C 
• Ctrl-A 

9. Which of these statements about creating charts is TRUE? 

• A. You cannot change the chart type even after it has been created. 
• B. Charts are always 2-dimensional 
• C. A chart cannot be moved once it's created. 
• D. You must select the data first 

10. Which chart is displaying the 3D version? 

• A
• B
• C