Microsoft Office Tutorials and References
In Depth Information
EX 4
EX 4
Excel Chapter 1 Creating a Worksheet and an Embedded Chart
Excel Chapter 1 Creating a Worksheet and an Embedded Chart
Excel 2007 Features
With its what-if
analysis tools, research
capabilities, collaboration
tools, streamlined user
interface, smart tags,
charting features, Web
capabilities, hundreds of
functions, and enhanced
formatting capabilities,
Excel 2007 is one of the
easier and more powerful
spreadsheet packages
available.
statement, source of data, summary of calculations, and any other special requirements
for the worksheet, such as charting and Web support. Figure 1–2 shows the requirements
document for the new workbook to be created in this chapter.
requirements
document
Worksheet
Development Cycle
Spreadsheet specialists
do not sit down and
start entering text,
formulas, and data into
a blank Excel worksheet
as soon as they have a
spreadsheet assignment.
Instead, they follow
an organized plan,
or methodology, that
breaks the development
cycle into a series of
tasks. The recommended
methodology for creating
worksheets includes:
(1) analyze
requirements (supplied in a
requirements document);
(2) design solution;
(3) validate design;
(4) implement design;
(5) test solution; and
(6) document solution.
Figure 1–2
Overview
As you read this chapter, you will learn how to create the worksheet shown in
Figure 1–1 by performing these general tasks:
• Enter text in the worksheet
• Add totals to the worksheet
• Save the workbook that contains the worksheet
• Format the text in the worksheet
• Insert a chart in the worksheet
• Save the workbook a second time using the same fi le name
• Print the worksheet
Plan
Ahead
General Project Guidelines
While creating an Excel worksheet, you need to make several decisions that will determine
the appearance and characteristics of the fi nished worksheet. As you create the worksheet
shown in Figure 1–1, you should follow these general guidelines:
1. Select titles and subtitles for the worksheet. Follow the less is more guideline. The less
text in the titles and subtitles, the more impact the titles and subtitles will have. Use
the fewest words possible to specify the information presented in the worksheet to the
intended audience.
(continued)
Search JabSto ::




Custom Search