Microsoft Office Tutorials and References
In Depth Information
Overview
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%
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 reso-
lution 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 Vista 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.
Note: If you are using Windows XP, see Appendix F for alternate steps.
1 Click the Start button on the Windows Vista taskbar to display the Start menu.
2 Click All Programs at the bottom of the left pane on the Start menu to display the All
Programs list.
3 Click Microsoft Offi ce in the All Programs list to display the Microsoft Offi ce list.
4 Click Microsoft Offi ce Excel 2007 to start Excel and display a blank worksheet in the Excel
window.
5 If the Excel window is not maximized, click the Maximize button next to the Close button
on its title bar to maximize the window.
6 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