Microsoft Office Tutorials and References
In Depth Information
Excel Chapter 1 Creating a Worksheet and an Embedded Chart
Home tab is active tab and
Chart Tools contextual tab
and related tabs disappear
• Click Style 2 in the Chart Styles
gallery to apply the chart style
Style 2 to the chart.
• Select other chart styles in the
Chart Styles gallery to apply other
chart styles to the chart, but select
Style 2 as your ﬁ nal choice.
• Click cell I9 to deselect the chart
and complete the worksheet
What is the purpose of the items
on the right side of the chart?
The items to the right of the
column chart in Figure 1–81 are
the legend , which identiﬁ es the
colors assigned to each bar in the
chart. Excel automatically selects
the entries in the leftmost column
of the chart range (column A) as
titles within the legend.
legend deﬁ nes
Style 2 chart style
applied to chart
Changing Document Properties and Saving Again
Excel helps you organize and identify your ﬁ les by using document properties , which are
the details about a ﬁ le. Document properties, also known as metadata , can include such
information as the project author, title, or subject. Keywords are words or phrases that
further describe the document. For example, a class name or worksheet topic can describe
the ﬁ le’s purpose or content. Document properties are valuable for a variety of reasons:
• Users can save time locating a particular ﬁ le because they can view a document’s
properties without opening the workbook.
• By creating consistent properties for ﬁ les having similar content, users can better
organize their workbooks.
• Some organizations require Excel users to add document properties so that other
employees can view details about these ﬁ les.
Five different types of document properties exist, but the more common ones used
in this topic are standard and automatically updated properties. Standard properties
are associated with all Microsoft Ofﬁ ce documents and include author, title, and subject.
Automatically updated properties include ﬁ le system properties, such as the date you
create or change a ﬁ le, and statistics, such as the ﬁ le size.
Excel allows you to assign
properties by clicking
the Document Properties
button arrow in the
panel and then clicking
You can assign custom
properties, such as
and Editor. Or, you
can create your own