Microsoft Office Tutorials and References
In Depth Information
he Mobile Mases Store
Biweekly Payroll Report
Xs indicate text
$ adjacent to Z indicates
l oating dollar sign
$ not adjacent to Z indicates
a i xed dollar sign
Zs indicate numeric
data with 0s suppressed
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
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
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
create folders, move
and rename i les, use
Windows Help, and
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
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.
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.
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.
If the Excel window is not maximized, click the Maximize button next to the Close button
on its title bar to maximize the window.