Name:     ID: 
 
Email: 

CompAppsCh7

True/False
Indicate whether the statement is true or false.
 

 1. 

A chart simplifies the understanding of numerical data.
 

 2. 

All charts contain the same objects.
 

 3. 

In a pie chart, the size of a slice varies with its percentage of the series total.
 

 4. 

A chart represents all of the data on the worksheet.
 

 5. 

An existing chart can be moved to a new location on the worksheet.
 

 6. 

Drag a corner handle to move a chart.
 

 7. 

A header and footer can be added to a chart sheet.
 

 8. 

A chart pasted as a picture will automatically change if the source worksheet changes.
 

 9. 

The category axis is vertical.
 

 10. 

The value axis is vertical.
 

 11. 

The data range of a chart can include non-adjacent cells.
 

 12. 

Column, bar, and line are the only types of charts that can be created in Excel.
 

 13. 

An adjacent data series is added to a selected chart by dragging a handle of the outlined original data series.
 

 14. 

A legend is always positioned to the right of a chart.
 

 15. 

Changing a chart’s theme only affects the chart and not the corresponding worksheet.
 

Multiple Choice
Identify the choice that best completes the statement or answers the question.
 

 16. 

The chart title
a.
describes what is charted.
c.
is the sum of the data range.
b.
is below the category labels.
d.
is also the vertical axis label.
 

 17. 

Which type of chart is best for charting data that is a percentage of a whole?
a.
bar
c.
line
b.
column
d.
pie
 
 
nar001-1.jpg
 

 18. 

Which type of chart is shown above?
a.
bar
c.
line
b.
column
d.
pie
 

 19. 

The first step in creating a pie chart is to
a.
select a location for the chart.
c.
select the chart type.
b.
select the data to be charted.
d.
verify the source data.
 

 20. 

A chart is sized proportionately by dragging
a.
a chart border.
c.
the middle left handle.
b.
a corner handle.
d.
the top middle handle.
 

 21. 

A selected chart is deleted by
a.
double-clicking a chart border.
c.
pressing the Delete key.
b.
double-clicking a corner handle.
d.
pressing the Esc key.
 

 22. 

What is printed if a chart that appears as an object in a worksheet is selected before printing?
a.
all the sheets and charts in the workbook
b.
only the chart on a single sheet of paper in landscape orientation
c.
the sheet and chart on a single sheet of paper in portrait orientation
d.
the sheet and chart on a single sheet of paper in landscape orientation
 

 23. 

Which type of chart is best for comparing the differences between values?
a.
bar
c.
line
b.
value
d.
pie
 

 24. 

Which type of chart would best illustrate price fluctuations over a period of time for three stocks?
a.
bar
c.
pie
b.
line
d.
area
 
 
nar002-1.jpg
 

 25. 

Which type of chart is shown above?
a.
column
c.
pie
b.
line
d.
area
 

 26. 

In the chart above, which is the first horizontal axis label?
a.
0
c.
2011
b.
Architecture
d.
Program
 

 27. 

In the chart above, which is the first vertical axis label?
a.
0
c.
2011
b.
Architecture
d.
Program
 

 28. 

Which chart type shows changes in values relative to a center point?
a.
XY (scatter) chart
c.
surface chart
b.
stock chart
d.
radar chart
 

 29. 

Which chart type compares sets of three values?
a.
bubble chart
c.
doughnut chart
b.
stock chart
d.
radar chart
 

 30. 

Which chart type shows trends of values over time?
a.
area chart
c.
doughnut chart
b.
stock chart
d.
radar chart
 



 
         Start Over