Microsoft Office Tutorials and References
In Depth Information
Entering the Titles and Numbers into the Worksheet
7
Type State Tax in cell G3 and then press the RIGHT ARROW key to enter the
column heading .
8
Type Tax % in cell H3 and then press the RIGHT ARROW key to enter the column heading.
9
Type Net Pay in cell I3 and then press the RIGHT ARROW key to enter the column
heading.
10 Type Hire Date in cell J3 and then press the RIGHT ARROW key to enter the
column heading.
To Enter the Salary Data
The salary 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, dependents, hours
worked, hourly pay rate, and hire date.
1
Select cell A4. Type Carl, Michael and then press the RIGHT ARROW key to enter
the employee name.
2
Type 3 in cell B4 and then press the RIGHT ARROW key to enter a number in the
selected cell.
3
Type 60.45 in cell C4 and then press the RIGHT ARROW key to enter a number in the
selected cell.
4
Type 19.50 in cell D4 and then press the RIGHT ARROW key to enter a number in the
selected cell.
5
Type 4/5/10 in cell J4 and then tap or click cell A5 to select the cell.
6
Enter the payroll data in Table 2 –1 for the eight remaining employees in rows 5
through 12 (shown in Figure 2 – 4 on page 72).
In Step 5, why did the date that was entered change from 4/5/10 to 4/5/2010?
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 HyperMass Online Storage Salary Report Data
Employee
Dependents
Hours Worked
Hourly Pay Rate
Hire Date
Carl, Michael
3
60.45
19.50
4/5/10
Green, Sue
0
81.50
22.85
7/15/11
Fekir, Sith
1
69.50
17.36
1/13/09
Lane, Jon
2
65.25
19.45
3/1/12
Nichols, Peter
3
71.25
12.60
4/15/11
Pearson, Ada
3
44.65
22.45
10/31/08
Rodriquez, Juan
2
55.50
20.15
7/15/09
Williams, Sean
0
80.00
20.85
5/14/09
Yau, Xin
4
70.00
18.75
6/17/02
 
Search JabSto ::




Custom Search