Microsoft Office Tutorials and References
In Depth Information
Entering the Titles and Numbers into the Worksheet
To Enter the Biweekly Payroll Data
The biweekly payroll data in Table 2 – 1 includes a hire date for each employee.
Excel considers a date to be a number and, therefore, it displays the date right-aligned
in the cell. The following steps enter the data for each employee: name, hire date,
dependents, hours worked, and hourly pay rate.
Q&As
For a complete list of the
Q&As found in many of
the step-by-step sequences
in this topic, visit the
Excel 2010 Q&A Web page
(scsite.com/ex2010/qa).
1
Select cell A4, type Charvat, Emily , and then press the RIGHT ARROW key to enter
the employee name.
2
Type 3/3/09 in cell B4 and then press the RIGHT ARROW key to enter a date in the
selected cell.
3
Type 1 in cell C4 and then press the RIGHT ARROW key to enter a number in the selected cell.
4
Type 65.25 in cell D4 and then press the RIGHT ARROW key to enter a number in the
selected cell.
5
Type 20.50 in cell E4 and then click cell A5 to enter a number in the selected cell.
Two-Digit Years
When you enter a two-
digit year value (xx) that is
less than 30, Excel changes
that value to 20xx; when
you enter a value that is
30 or greater (zz), Excel
changes the value to 19zz.
Use four-digit years, if
necessary, to ensure that
Excel interprets year values
the way you intend.
6
Enter the payroll data in Table 2 – 1 for the eight remaining employees in rows 5 through 12
(Figure 2 – 4).
In step 2, why did the date that was entered change from 3/3/09 to 3/3/2009?
When Excel recognizes that you entered a date in mm/dd/yy format, it automatically
formats the date as mm/dd/yyyy for you. Most professionals prefer to view dates in mm/
dd/yyyy format as opposed to mm/dd/yy format because the latter can cause confusion
regarding the intended year. For example, a date displayed as 3/3/50 could imply a date
of 3/3/1950 or 3/3/2050. The use of a four-digit year eliminates this confusion.
Table 2 – 1 The Mobile Masses Store Biweekly Payroll Report Data
Employee
Hire Date
Dependents
Hours Worked
Hourly Pay Rate
Charvat, Emily
3/3/09
1
65.25
20.50
Chen, Bin
6/14/10
2
80.00
25.85
Felski, Noah
10/11/08
0
64.50
12.60
Kersey, Jane
3/4/11
1
68.50
21.45
Wrapping Text
If you have a long text
entry, such as a paragraph,
you can instruct Excel to
wrap the text in a cell. This
method is easier than your
pressing ALT + ENTER to end
each line of text within
the paragraph. To wrap
text, right-click in the cell,
click Format Cells on a
Alignment tab, and then
click Wrap text. Excel will
increase the height of the
cell automatically so that
i t. If you want to control
where each line ends
in the cell, rather than
letting Excel wrap the text
based on the cell width,
you must end each line
with ALT + ENTER .
Merna, Thomas
1/15/10
3
78.25
22.60
Pollitt, Sherry
11/15/08
2
49.25
18.25
2/15/08
0
33.50
9.35
Washington, Yolanda
5/11/06
2
79.25
23.75
Zica, James
4/14/11
1
80.00
19.65
To Enter the Row Titles
The following steps add row titles for the rows that will contain the totals, average,
highest, and lowest amounts.
1
Select cell A13. Type Totals and then press the DOWN ARROW key to enter a row header.
2
3
Type Average in cell A14 and then press the DOWN ARROW key to enter a row header.
Type Highest in cell A15 and then press the DOWN ARROW key to enter a row header.
4
Type Lowest in cell A16 and then press the ENTER key to enter a row header. Select
cell F4 to prepare to enter a formula in the cell (Figure 2 – 4).

Search JabSto ::

Custom Search