What-If Analysis, Charting, And Working With Large Worksheets Page 7
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 143
With a solid understanding of the requirements document, an understanding of the
necessary decisions, and a sketch of the worksheet, the next step is to use Excel to create
the worksheet.
Table 3 – 1 Modern Music Shops Six-Month Financial Projections Data
and What-If Assumptions
Projected Monthly Total Sales Revenues
July
$3,113,612.16
August
7,962,235.53
September
5,112,268.58
October
2,924,627.87
November
7,630,534.65
December
3,424,270.23
What-If Assumptions
Bonus
$200,000.00
Commission
5.75%
Margin
57.50%
Marketing
15.00%
Research and Development
7.50%
Sales Revenue for Bonus
$3,500,000.00
Support, General, and Administrative
18.75%
To Start Excel
For an introduction
to Windows 7 and
If you are using a computer to step through the project in this chapter and you want
instruction about
your screens to match the fi gures in this book, you should change your screen’s resolution
how to perform basic
to 1024 × 768. For information about how to change a computer’s resolution, refer to the
Windows 7 tasks, read
Introduction to Offi ce 2010 and Windows 7 chapter at the beginning of this book.
the Offi ce 2010 and
Windows 7 chapter at
The following steps, which assume Windows 7 is running, start Excel based on a
the beginning of this
typical installation. You may need to ask your instructor how to start Excel for your com-
book, where you can
puter. For a detailed example of the procedure summarized below, refer to the Offi ce 2010
learn how to resize
and Windows 7 chapter at the beginning of this book.
windows, change
screen resolution,
1
Click the Start button on the Windows 7 taskbar to display the Start menu.
create folders, move
and rename fi les, use
2
Microsoft Excel
Type
as the search text in the ‘Search programs and fi les’ text
Windows Help, and
box, and watch the search results appear on the Start menu.
much more.
3
Click Microsoft Excel 2010 in the search results on the Start menu to start Excel and display
a new blank workbook in the Excel window.
4
If the Excel window is not maximized, click the Maximize button next to the Close button
on its title bar to maximize the window.
ADVERTISEMENT
0 votes
Related Articles
Related forms
Related Categories
Parent category: Education