What-If Analysis, Charting, And Working With Large Worksheets Page 74
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
87EX 210
Excel Chapter 3
What-If Analysis, Charting, and Working with Large Worksheets
continued
In the Lab
Figure 3 – 87
Instructions Part 1:
1. Start Excel. Apply the Civic theme to the worksheet by using the Themes button (Page Layout tab |
Themes group). Bold the entire worksheet by selecting the entire worksheet and using the Bold
button (Home tab | Font group).
2. Enter the worksheet title Med Supply Online Warehouse in cell A1 and the subtitle
Six-Year Financial Projection in cell A2. Format the worksheet title in cell A1 to
36-point Copperplate Gothic Bold (or a similar font). Format the worksheet subtitle in cell A2
to 20-point Verdana (or a similar font). Enter the system date in cell G2 using the NOW function.
Format the date to the 14-Mar-01 style.
3. Change the following column widths: A = 25.00 characters; B through H = 15.00 characters.
Change the heights of rows 7, 15, 17, 19, and 22 to 18.00 points.
4. Enter the six column titles Year 1 through Year 6 in the range B3:G3 by entering Year 1 in cell B3
and then dragging cell B3’s fi ll handle through the range C3:G3. Format cell B3 as follows:
(a) increase the font size to 14; (b) center and italicize it; and (c) angle its contents clockwise.
Use the Format Painter button (Home tab | Clipboard group) to copy the format assigned to
cell B3 to the range C3:G3.
ADVERTISEMENT
0 votes
Related Articles
Related forms
Related Categories
Parent category: Education