Microsoft Office Tutorials and References
In Depth Information
Introduction
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
instruction about
how to perform basic
Windows 7 tasks, read
the Ofi ce 2010 and
Windows 7 chapter at
the beginning of this
book, where you can
learn how to resize
windows, change
screen resolution,
create folders, move
and rename i les, use
Windows Help, and
much more.
If you are using a computer to step through the project in this chapter and you want
your screens to match the i gures in this topic, you should change your screen’s resolution
to 1024
768. For information about how to change a computer’s resolution, refer to the
Introduction to Ofi ce 2010 and Windows 7 chapter at the beginning of this topic.
The following steps, which assume Windows 7 is running, start Excel based on a
typical installation. You may need to ask your instructor how to start Excel for your com-
puter. For a detailed example of the procedure summarized below, refer to the Ofi ce 2010
and Windows 7 chapter at the beginning of this topic.
×
1
Click the Start button on the Windows 7 taskbar to display the Start menu.
2
Type Microsoft Excel as the search text in the ‘Search programs and i les’ text
box, and watch the search results appear on the Start menu.
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.
 
Search JabSto ::




Custom Search