Microsoft Office Tutorials and References
In Depth Information
Entering the Titles and Numbers into the Worksheet
Entering the Titles and Numbers
into the Worksheet
For an introduction to
office and instruction
about how to perform
basic tasks in office
programs, read the
office and Windows
chapter at the beginning
of this topic, where you
can learn how to run
a program, use the
ribbon, save a le, open
a le, exit a program, use
Help, and much more.
The rst step in creating the worksheet is to enter the titles and numbers into the
worksheet. The following sets of steps enter the worksheet title and subtitle and then
the salary report data shown in Table 2–1 on page EX 71.
To Enter the Worksheet Title and Subtitle
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.
The following steps enter the worksheet title and subtitle into cells A1 and A2.
If necessary, select cell A1. Type HyperMass Online Storage in the selected
cell and then press the DOWN ARROW key to enter the worksheet title.
Type Salary Report in cell A2 and then press the DOWN ARROW key to enter the
To Enter the Column Titles
The employee names and the row titles Totals, Average, Highest, and Lowest
in the leftmost column begin in cell A4 and continue down to cell A16. The employee
data is entered into rows 4 through 12 of the worksheet. The remainder of this section
explains the steps required to enter the column titles, payroll data, and row titles, as
shown in Figure 2 – 4, and then save the workbook.
The column titles in row 3 begin in cell A3 and extend through cell J3. Some of
the column titles in Figure 2 – 4 include multiple lines of text, such as Hours Worked
in cell C3. To start a new line in a cell, press + after each line, except for the
last line, which is completed by tapping or clicking the Enter box, pressing the
key, or pressing one of the arrow keys. When you see + in a step, press the
key while holding down the key and then release both keys. The following
steps enter the column titles.
With cell A3 selected, type Employee and then press the RIGHT ARROW key to enter
the column heading.
Type Dependents and then press the RIGHT ARROW key to enter the column
In cell C3, type Hours and then press ALT + ENTER to enter the rst line of the column
heading. Type Worked and then press the RIGHT ARROW key to enter the column
Type Hourly in cell D3 and then press ALT + ENTER to begin a new line in the cell.
Type Pay Rate and then press the RIGHT ARROW key to enter the column heading.
Type Gross Pay in cell E3 and then press the RIGHT ARROW key to enter the
column heading .
Type Federal Tax in cell F3 and then press the RIGHT ARROW key to enter the