What-If Analysis, Charting, And Working With Large Worksheets Page 8
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 144
Excel Chapter 3
What-If Analysis, Charting, and Working with Large Worksheets
To Enter the Worksheet Titles, Change Document Properties,
For an introduction
Apply a Theme, and Save the Workbook
to Offi ce 2010 and
instruction about
The worksheet contains two titles, initially in cells A8 and A9. In the previous
how to perform
basic tasks in Offi ce
chapters, titles were centered across the worksheet. With large worksheets that extend
2010 programs, read
beyond the size of a window, it is best to enter titles left-aligned as shown in the sketch of
the Offi ce 2010 and
the worksheet in Figure 3 –3a because the worksheet prints with the title on the fi rst page
Windows 7 chapter
if the worksheet requires multiple pages, and the user more easily fi nds the worksheet
at the beginning of
title when necessary. The following steps enter the worksheet titles, change the workbook
this book, where you
theme to Opulent, change document properties, and then save the workbook.
can learn how to start
a program, use the
1
Modern Music Shops
Select cell A8 and then type
as the worksheet title.
Ribbon, save a fi le,
open a fi le, quit a
2
Six-Month Financial Projection
Select cell A9 and then type
as the
program, use Help,
worksheet subtitle and then press the
key to enter the worksheet subtitle.
ENTER
and much more.
3
Change the document properties as specifi ed by your instructor.
4
Apply the Opulent theme to the workbook.
5
With a USB fl ash drive connected to one of the computer’s USB ports, click the Save
The Ribbon and Screen
Resolution
button on the Quick Access Toolbar to display the Save As dialog box.
Excel may change how
6
Modern Music Shops Six-Month Financial Projection
the groups and buttons
Type
in
within the groups appear
the File name text box to change the fi le name. Do not press the
key after typing
ENTER
on the Ribbon, depending
the fi le name because you do not want to close the dialog box at this time.
on the computer’s screen
resolution. Thus, your
7
Navigate to the desired save location (in this case, the Excel folder in the CIS 101 folder
Ribbon may look different
[or your class folder] on the USB fl ash drive).
from the ones in this book
8
if you are using a screen
Click the Save button (Save As dialog box) to save the document in the selected folder
resolution other than
on the selected drive with the entered fi le name.
1024 x 768.
Rotating Text and Using the Fill
Handle to Create a Series
The data on the worksheet, including month names and the What-If Assumptions section,
now can be added to the worksheet.
BTWs
For a complete
Plan
Plan the layout of the worksheet.
list of the BTWs
Ahead
Excel allows you to rotate text in a cell. Rotated text often provides a strong visual appeal.
found in the
Rotated text also allows you to fi t more text into a smaller column width. Chapters 1 and 2
margins of
used the fi ll handle to copy a cell or a range of cells to adjacent cells. The fi ll handle also
this book, visit
allows creation of a series of numbers, dates, or month names automatically. Using the fi ll
the Excel 2010
handle in this way eliminates the need to type in such data, saving time and eliminating
BTW Web page
typographical errors.
(
ex2010/btw).
ADVERTISEMENT
0 votes
Related Articles
Related forms
Related Categories
Parent category: Education