What-If Analysis, Charting, And Working With Large Worksheets Page 37
ADVERTISEMENT
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87What-If Analysis, Charting, and Working with Large Worksheets
Excel Chapter 3
EX 173
Formatting the Worksheet
The worksheet created thus far shows the fi nancial projections for the six-month
period, from July to December. Its appearance is uninteresting, however, even though
some minimal formatting (formatting assumptions numbers, changing the column
widths, formatting the date, and formatting the Sparkline chart) was performed earlier.
This section will complete the formatting of the worksheet to make the numbers
easier to read and to emphasize the titles, assumptions, categories, and totals as shown
in Figure 3– 40.
Plan
Identify how to format various elements of the worksheet.
Ahead
A worksheet, such as the one presented in this chapter, should be formatted in the following
manner: (1) format the numbers; (2) format the worksheet title, column titles, row titles,
and total rows; and (3) format an assumptions table. Numbers in heading rows and total
rows should be formatted with a currency symbol. Other dollar amounts should be format-
ted with a Comma style. An assumptions table should be diminished in its formatting so
that it does not distract from the main calculations and data in the worksheet. Assigning
the data in an assumptions table a smaller font size would set it apart from other data
formatted with a larger font size.
14-point italic
underlined font
ranges A10:I11 and
A1:B8 have purple
background
font in range
A2:B8 is 8-point
36-point font
height of rows
10 through 12
are best fi t
Comma style
Currency style
with fl oating
dollar sign
Figure 3 – 40
ADVERTISEMENT
0 votes
Related Articles
Related forms
Related Categories
Parent category: Education