Microsoft Office Tutorials and References
In Depth Information
Excel Chapter 3 What-If Analysis, Charting, and Working with Large Worksheets
Identify how to format various elements of the worksheet.
The worksheet will be formatted in the following manner so it appears as shown in Figure 3–35:
(1) format the numbers; (2) format the worksheet title, column titles, row titles, and operating
income row; and (3) format the assumptions table. Numbers in heading rows and total rows
should be formatted with a currency symbol. Other dollar amounts should be formatted with a
Comma style. The assumptions table should be diminished in its formatting so it does not distract
from the main calculations and data in the worksheet. Assigning the data in the assumptions table
a font size of 8-point would set it apart from other data formatted with a font size of 11-point.
One of the more
difficult tasks to
learn is selecting
To complete this task,
do not hold down the
CTRL key when you
select the first range
because Excel will
consider the current
active cell to be the
first selection. Once the
first range is selected,
hold down the CTRL key
and drag through the
nonadjacent ranges. If
a desired range is not
visible in the window,
use the scroll arrows
to view the range. It is
not necessary to hold
down the CTRL key
while you scroll.
height of rows
1 through 3
are best ﬁ t
with ﬂ oating
font in range
A19:B25 is 8
To Assign Formats to Nonadjacent Ranges
The numbers in the range B4:H16 are to be formatted as follows:
1. Assign the Currency style with a ﬂ oating dollar sign to rows 4, 6, 9, 14, and 16.
2. Assign a Comma style to rows 5 and 10 through 13.
To assign a Currency style with a ﬂ oating dollar sign, use the Format Cells dialog box rather than the
Accounting Style button on the Ribbon, which assigns a ﬁ xed dollar sign. Also use the Format Cells dialog box to
assign the Comma style, because the Comma Style button on the Ribbon assigns a format that displays a dash (-)
when a cell has a value of 0. The speciﬁ cations for this worksheet call for displaying a value of 0 as 0.00 (see cell B9
in Figure 3–35), rather than as a dash. To create a Comma style using the Format Cells dialog box, you can assign a
Currency style with no dollar sign. The following steps assign formats to the numbers in rows 4 through 16.