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 5–1 Column Information for Silver Photography Accessories Sales Rep Table
Column
Headings
(Field
Names)
Column in
Worksheet
Type of Data
Column
Width
Description as It Pertains to a
Sales Rep
Name
A
Text
16.43
Last name and fi rst name
Gender
B
Text
11.57
Male or female
Age
C
Numeric
8.29
Age in years
Hire Date
D
Date
13.14
Date hired
State
E
Text
9.43
Sales territory
Sales Area
F
Text
14.00
Inside or outside sales
Quota
G
Numeric
13.29
Annual sales quota
YTD Sales
H
Numeric
13.29
Year-to-date sales
% of Quota
I
YTD Sales / Quota
14.57
Percent of annual quota met
Grade
J
VLOOKUP function
10.29
Grade indicates how much of quota has
been met
To Start Excel
Starting 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
fi le name in Windows
Explorer.
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 21 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.
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