Microsoft Office Tutorials and References
In Depth Information
Project — Financial Projection Worksheet with What-If Analysis and Chart EX 167
With a good 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 Campus Clothiers Semiannual Financial
Projections Data and What-If Assumptions
Projected Monthly Total Net
Revenues
January
$3,383,909.82
February
6,880,576.15
March
9,742,702.37
April
4,818,493.53
May
4,566,722.63
June
8,527,504.39
What-If Assumptions
Bonus
$100,000.00
Commission
3.25%
Margin
61.00%
Marketing
9.00%
Research and Development
5.75%
Revenue for Bonus
$4,750,000.00
Support, General, and Administrative
17.00%
The Startup Submenu
Any application on the
Startup submenu starts
automatically when
you turn your computer
on. To add Excel to the
Startup submenu, do
the following: (1) Click
the Start button on the
Windows taskbar, point
to All Programs on the
Start menu, and then
point to Microsoft Offi ce
on the All Programs
submenu; (2) Right-drag
Microsoft Offi ce Excel
2007 from the Microsoft
Offi ce submenu to the
Startup submenu; (3)
When the shortcut menu
appears, click Copy Here.
The next time you turn
your computer on, Excel
will start automatically.
To Start Excel
If you are using a computer to step through the project in this chapter and you want
your screen to match the fi gures in this topic, you should change your computer’s
resolution to 1024
768. For information about how to change a computer’s resolution, see
page APP 36 in Appendix E.
The following steps, which assume Windows is running, start Excel based on a typical
installation of Microsoft Offi ce on your computer. You may need to ask your instructor
how to start Excel for your computer.
1 Click the Start button on the Windows taskbar to display the Start menu.
2 Point to All Programs on the Start menu and then point to Microsoft Offi ce in the All
Programs submenu.
3 Click Microsoft Offi ce Excel 2007 on the Microsoft Offi ce submenu.
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.
5 If the worksheet window in Excel is not maximized, click the Maximize button next to the
Close button on its title bar to maximize the worksheet window within Excel.
 
Search JabSto ::




Custom Search