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 Ofi ce 2010 and
instruction about
how to perform
basic tasks in Ofi ce
2010 programs, read
the Ofi ce 2010 and
Windows 7 chapter
at the beginning of
this topic, where you
can learn how to start
a program, use the
Ribbon, save a i le,
open a i le, quit a
program, use Help,
and much more.
The i 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
biweekly payroll report data shown in Table 2 – 1.
To Enter the Worksheet Title and Subtitle
The following steps enter the worksheet title and subtitle into cells A1 and A2.
1
If necessary, select cell A1. Type The Mobile Masses Store in the selected cell
and then press the DOWN ARROW key to enter the worksheet title.
2
Type Biweekly Payroll Report in cell A2 and then press the DOWN ARROW key
to enter the worksheet subtitle (Figure 2 – 4 on page 73).
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.
To Enter the Column Titles
The Ribbon and Screen
Resolution
Excel may change how
the groups and buttons
within the groups appear
on the Ribbon, depending
on the computer’s screen
resolution. Thus, your
Ribbon may look different
from the ones in this topic
if you are using a screen
resolution other than
1024
The column titles in row 3 begin in cell A3 and extend through cell J3. Some of
the column titles in Figure 2 – 3 include multiple lines of text, such as Hours Worked in
cell D3. To start a new line in a cell, press alt + enter after each line, except for the last
line, which is completed by clicking the Enter box, pressing the enter key, or pressing one
of the arrow keys. When you see alt + enter in a step, press the enter key while holding
down the alt key and then release both keys. The following steps enter the column titles.
1
With cell A3 selected, type Employee and then press the RIGHT ARROW key to enter the
column heading.
×
768.
2
Type Hire Date in cell B3 and then press the RIGHT ARROW key to enter the column
heading.
3
Type Dependents and then press the RIGHT ARROW key to enter the column heading.
4
In cell D3, type Hours and then press ALT + ENTER to enter the i rst line of the column
heading. Type Worked and then press the RIGHT ARROW key to enter the column heading.
5
Type Hourly 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.
6
Type Gross Pay in cell F3 and then press the RIGHT ARROW key to enter the column
heading .
7
Type Federal Tax in cell G3 and then press the RIGHT ARROW key to enter the column
heading.
8
Type State Tax in cell H3 and then press the RIGHT ARROW key to enter the column
heading .
BTWs
For a complete list of the
BTWs found in the margins
of this topic, visit the
Excel 2010 BTW Web page
(scsite.com/ex2010/btw).
9
Type Net Pay in cell I3 and then press the RIGHT ARROW key to enter the column
heading.
10
Type Tax % in cell J3 to enter the column heading.
 
Search JabSto ::




Custom Search