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.
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
Select cell A4, type Charvat, Emily , and then press the RIGHT ARROW key to enter
the employee name.
Type 3/3/09 in cell B4 and then press the RIGHT ARROW key to enter a date in the
Type 1 in cell C4 and then press the RIGHT ARROW key to enter a number in the selected cell.
Type 65.25 in cell D4 and then press the RIGHT ARROW key to enter a number in the
Type 20.50 in cell E4 and then click cell A5 to enter a number in the selected cell.
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.
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
Hourly Pay Rate
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
shortcut menu, click the
Alignment tab, and then
click Wrap text. Excel will
increase the height of the
cell automatically so that
the additional lines will
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 .
To Enter the Row Titles
The following steps add row titles for the rows that will contain the totals, average,
highest, and lowest amounts.
Select cell A13. Type Totals and then press the DOWN ARROW key to enter a row header.
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.
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).