Microsoft Office Tutorials and References
In Depth Information
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
Table 5–1 Column Information for Silver Photography Accessories Sales Rep Table
Type of Data
Description as It Pertains to a
Last name and ﬁ rst name
Male or female
Age in years
Inside or outside sales
Annual sales quota
% of Quota
YTD Sales / Quota
Percent of annual quota met
Grade indicates how much of quota has
To Start Excel
If you plan to open an
existing workbook, you
can start Excel and open
the workbook at the
same time by double-
clicking the workbook
ﬁ le name in Windows
If you are using a computer to step through the project in this chapter and you want
your screen to match the ﬁ gures in this topic, you should change your computer’s resolution
768. For information about how to change a computer’s resolution, see page
APP 21 in Appendix E.
The following steps, which assume Windows is running, start Excel based on a typical
installation of Microsoft Ofﬁ ce on your computer. You may need to ask your instructor how
to start Excel for your computer.
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
3 Click Microsoft Ofﬁ ce in the All Programs list to display the Microsoft Ofﬁ ce list.
4 Click Microsoft Ofﬁ ce Excel 2007 to start Excel and display a blank worksheet in the Excel
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.