Microsoft Office Tutorials and References
In Depth Information
EX 54
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 fi nal choice.
I9 is
active cell
Click cell I9 to deselect the chart
and complete the worksheet
(Figure 1–81).
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 identifi 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 defi nes
columns in
chart area
Style 2 chart style
applied to chart
Figure 1–81
Changing Document Properties and Saving Again
Excel helps you organize and identify your fi les by using document properties , which are
the details about a fi 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 fi le’s purpose or content. Document properties are valuable for a variety of reasons:
• Users can save time locating a particular fi le because they can view a document’s
properties without opening the workbook.
• By creating consistent properties for fi 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 fi 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 Offi ce documents and include author, title, and subject.
Automatically updated properties include fi le system properties, such as the date you
create or change a fi le, and statistics, such as the fi le size.
Document Properties
Excel allows you to assign
additional document
properties by clicking
the Document Properties
button arrow in the
Document Information
panel and then clicking
Advanced Properties.
You can assign custom
properties, such as
Department, Purpose,
and Editor. Or, you
can create your own
document properties.
Search JabSto ::

Custom Search