Download Starting Excel 2007

Worksheet Basics
Entering Values
Now that you know how to enter labels, it’s time to work
with the other basic type of worksheet information:
values. Values are the numerical data in a worksheet that
are used in calculations. A value can be any type of
numerical information: numbers, percentages, fractions,
currencies, dates, and times.
Exercise Notes
• Exercise File: Sales2-2 xlsx
• Exercise: Enter the following values in the cell range
E7:E10: 3500, 800, 7000, 4000.
Entering values in a worksheet is no different from
entering labels—you simply type the value and confirm
the entry.
1. Click a cell and type a value.
2. Press <Enter> or <Tab> to confirm the entry.
Tips
Excel treats information that contains numbers, dates
or times as a value and automatically right-aligns it in
the cell.
Values don’t have to contain only numbers. You can
also use numerical punctuation such as a period or a
dollar sign.
Figure 2-5: Entering a value in a cell.
You can reformat dates after entering them. For
example, if you enter 4/4/07, you can easily reformat
to April 4, 2007.
DoubleTechs.com Remote Computer Repair
Page 26