Name:     ID: 
 
Email: 

Microsoft Excel Lesson 8

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

 1. 

When you select the data source for a chart, you should also include the text you want to use as labels in the chart.
 

 2. 

Embedded charts are useful when you want to print a chart next to the data the chart illustrates.
 

 3. 

A chart sheet does not have worksheet cells and cannot contain data or formulas.
 

 4. 

A chart template formats the chart based on the colors, fonts, and effects associated with the workbook’s theme.
 

 5. 

You can delete a selected chart by pressing the F2 key.
 

 6. 

When you select the chart style, click a 3-D chart subtype to create a 3-D chart.
 

 7. 

Pie charts can be harder to design because you must designate which data should be used on each axis.
 

 8. 

To make changes to an element’s fill, border color, border style, shadow, 3-D format, alignment, and so forth, you need to open the Chart Elements dialog box.
 

 9. 

You use special chart text formatting tools to make changes to the fonts used in the chart.
 

 10. 

All chart types are interchangeable. For example, data suitable for a pie chart will also always work as a scatter chart.
 

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

 11. 

You can rename a chart sheet like any other worksheet. Right-click its sheet tab, and then click ____ on the shortcut menu.
a.
Text box
c.
File name
b.
Rename
d.
Chart name
 

 12. 

A selected chart element is surrounded by a ____.
a.
fill box
c.
text box
b.
selection box
d.
border
 

 13. 

You switch between a chart sheet and a worksheet by clicking the appropriate ____.
a.
sheet tabs
c.
icon
b.
file name
d.
data marker
 

 14. 

The chart element called ____ is a grid that displays the data plotted in the chart.
a.
data label
c.
data table
b.
data series
d.
data marker
 

 15. 

You can use the Ribbon to select chart elements. Click the Format tab or the ____ tab on the Ribbon. In the Current Selection group, click the arrow next to the Chart Elements box.
a.
Chart
c.
Layout
b.
Home
d.
Design
 

 16. 

A ____ chart shows the relationship of a part to a whole.
a.
pie
c.
line
b.
column
d.
scatter
 

 17. 

The quickest way to select a chart element is to ____.
a.
navigate using the Ribbon
c.
click it with the pointer
b.
use the shortcut menus
d.
none of the above
 

 18. 

You can quickly choose a layout and styles for a selected chart from the Ribbon. Click the ____ tab under Chart Tools on the Ribbon. In the Chart Layouts group, click the chart layout you want to use.
a.
Format
c.
Styles
b.
Edit
d.
Design
 

 19. 

To access the Format dialog box, select the chart you want to edit. Then, on the Format tab under Chart Tools on the Ribbon, in the Current Selection group, click the ____ button.
a.
Format
c.
Format Selection
b.
Selection
d.
Chart Selection
 

 20. 

____ charts are also used to illustrate a company’s market share in comparison to its competitors.
a.
Column
c.
Line
b.
Bar
d.
Pie
 
 
FIGURE EX 8-1

nar001-1.jpg
 

 21. 

In Figure EX 8-1 above, the phrase “Median Income” is the ____.
a.
legend
c.
horizontal axis title
b.
vertical axis title
d.
chart title
 

 22. 

In Figure EX 8-1 above, under “Education Pays,” the red and blue boxes labeled “Men” and “Women” is the ____.
a.
legend
c.
horizontal axis title
b.
vertical axis title
d.
chart title
 
 
Case EX 8-1
Candace wants to create a chart sheet similar to the one shown above.
 

 23. 

Candace now has the Move Chart dialog box open and wants to name her new chart sheet.  Where does she fill in the new name?
a.
In the Move sheet box
c.
In the New sheet box
b.
In the New object box
d.
In the Move object box
 
 
Case EX 8-2
Paco wants to change some of the elements in his chart, including the fill and border color.
 

 24. 

What type of dialog box does Paco need to access to make these changes? 
a.
Format dialog box
c.
Style dialog box
b.
Chart dialog box
d.
Layout dialog box
 

 25. 

On a separate chart that he is working on, Paco needs to access the Format dialog box for the chart legend.  First, he selects the chart he wants to edit. Then, on the ____ tab under Chart Tools on the Ribbon, in the Current Selection group, he clicks the Format Selection button.
a.
Layout
c.
Data
b.
Page Layout
d.
Format
 

Matching
 
 
Identify the letter of the choice that best matches the phrase or definition.
a.
Chart layout
b.
Chart
c.
Chart style
d.
Chart area 
e.
Chart sheet
 

 26. 

The entire chart and all other chart elements.
 

 27. 

Specifies which elements are included in a chart and where they are placed.
 

 28. 

A separate sheet in the workbook that stores a chart.
 

 29. 

Formats the chart based on the colors, fonts, and effects associated with the workbook’s theme.
 

 30. 

A graphical representation of data.
 



 
         Start Over