Microsoft Office Tutorials and References
In Depth Information
Project—Worksheet with Formulas, Functions, and Web Queries EX 85
Plan
Ahead
General Project Decisions
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
required to meet the requirements shown in Figure 2–2, you should follow these general
guidelines:
1. Plan the layout of the worksheet. As discussed in Chapter 1 and shown in Figure 2–3,
rows typically contain items analogous to items in a list. In the case of the stock club’s
data, the individual stocks serve this purpose and each stock should be placed in a row. As
the club adds more stocks, the number of rows in the worksheet will increase. Information
about each stock and associated calculations should appear in columns.
2. Determine the necessary formulas and functions needed. Values such as initial cost and
current value are calculated from known values. The formulas for these calculations
should be known in advance of creating the worksheet. Values such as the average,
highest, and lowest values can be calculated using Excel functions as opposed to relying on
complex formulas.
3. Identify how to format various elements of the worksheet. As discussed in Chapter 1 and
shown in Figure 2–3, the appearance of the worksheet affects its ability to communicate
clearly. Numeric data should be formatted in generally accepted formats, such as using
commas as thousands separators and parentheses for negative values.
4. Establish rules for conditional formatting. Conditional formatting allows you to format a
cell based on the contents of the cell. Decide under which circumstances you would like
a cell to stand out from similar cells and determine in what way the cell will stand out. In
the case of the Percent Gain/Loss column on the worksheet, placing a different background
color in cells that show losses is an appropriate format for the column.
5. Specify how the printed worksheet should appear. When it is possible that a person will
want to print a worksheet, care should be taken in the development of the worksheet to
ensure that the contents can be printed in a readable manner. Excel prints worksheets in
landscape or portrait orientation and margins can be adjusted to fi t more or less data on
each page. Headers and footers add an additional level of customization to the printed page.
(continued)
9s indicate
numeric data
Xs indicate
text data
$ not adjacent to
Z indicates a fi xed
dollar sign
Zs indicate
numeric data with
0s suppressed
$ adjacent to Z
indicates fl oating
dollar sign
Figure 2–3
C6161_EXC_02.4c.indd 85
C6161_EXC_02.4c.indd 85
3/6/07 3:28:02 PM
3/6/07 3:28:02 PM
Search JabSto ::




Custom Search