Microsoft Office Tutorials and References
In Depth Information
Introduction
he Mobile Mases Store
Biweekly Payroll Report
Hire
Date
99/99/99
Hours
Worked
99.99
Hourly
Pay Rate
$ ZZ9.99
Federal
Ta x
$ ZZ9.99
Emplyee
xxxxxxxxx
Dependents
Gros Pay
$ ZZ,ZZ9.99
State Tax
$ ZZ,ZZ9.99
Net Pay
$ ZZ,ZZ9.99
Tax %
Z9.99%
99
Ttals
Average
Highest
Lowest
999.99
99.99
$ ZZZ,ZZ9.99
$ ZZZ,ZZ9.99
$ ZZZ,ZZ9.99
$ ZZZ,ZZ9.99
$ ZZZ,ZZ9.99
$ ZZZ,ZZ9.99
$ ZZZ,ZZ9.99
$ ZZZ,ZZ9.99
Z9.99%
99
$ ZZ9.99
99
99
Z9.99%
Xs indicate text
data
$ adjacent to Z indicates
l oating dollar sign
$ not adjacent to Z indicates
a i xed dollar sign
9s indicate
numeric data
Zs indicate numeric
data with 0s suppressed
Figure 2–3
6. The commas indicate that the selected format should instruct Excel to display
a comma separator only if the number has enough digits to the left of the
decimal point.
7. The percent sign (%) in the far-right column indicates a percent sign should
appear after the number.
With a good comprehension 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.
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
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
computer. For a detailed example of the procedure summarized below, refer to the
Ofi ce 2010 and Windows 7 chapter.
×
1
2
Click the Start button on the Windows 7 taskbar to display the Start menu.
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