Microsoft Office Tutorials and References
In Depth Information
The purpose of the Internet Assignments is to challenge you to find information on the
Internet that you can use to work effectively with this software. The actual assignments are
updated and maintained on the Course Technology Web site. Log on to the Internet and
use your Web browser to go to the Student Online Companion for New Perspectives
then navigate to the assignments for this tutorial.
Use the Internet to find
and work with data
related to the topics pre-
sented in this tutorial.
SAM Assessment and Training
If your instructor has chosen to use the full online version of SAM 2003 Assessment and
Training, you can go beyond the “just-in-time” training provided on the CD that accompa-
nies this text. Simply log in to your SAM account ( http://sam2003.course.com) to launch
any assigned training activities or exams that relate to the skills covered in this tutorial.
Quick Check Answers
1. A chart type is one of the 14 styles of charts supported by Excel. Each chart type has
various alternate formats, called chart sub-types.
2. stock chart
3. A data series is a range of data values that is plotted on a chart.
4. The plot area contains the actual data values that are plotted in the chart, as well as any
background colors or images for that plot. The chart area contains the plot area and any
other element (such as titles and legend boxes) that may be included in the chart.
5. Gridlines are lines that extend out from the tick marks on either axis into the plot area.
6. embedded charts, which are placed within a worksheet, and chart sheets, which con-
tain only the chart itself
8. exploded pie
1. Click Chart on the menu bar, click Source Data, click the Series tab, select the data
series in the Series list box, and then click the Remove button.
2. Click Chart on the menu bar, click Location, and then select a new location.
3. Label text is text that consists of category names, tick mark labels, and legend text.
Attached text is text that is attached to other elements of the chart, such as the chart
title or axes titles. Unattached text is additional text that is unassociated with any par-
ticular element of the chart.
4. Major tick marks are tick marks that appear on the axis alongside the axis values.
Minor tick marks do not appear alongside any axis value, but instead are used to pro-
vide a finer gradation between major tick marks.
5. Click Chart on the menu bar, click Chart Type, and then select one of the 3-D chart
sub-types for the column chart.
6. An AutoShape is a predefined shape available on the Drawing toolbar. You can add
an AutoShape to any worksheet or chart. You can change the size or shape of an
AutoShape, and you can change its fill color.
7. Use full page, in which the chart is resized to fit the full size of the printed page (the
proportions of the chart may change in the resizing); Scale to fit page, in which
the chart is resized to fit the page but retains its proportions; and Custom, in
which the dimensions of the printed chart are specified in the chart sheet.