Microsoft Office Tutorials and References
In Depth Information
Entering Excel Data
Anything you can type into a
worksheet’s cell can be called data. Whenever you
type something into a cell, Excel tries to
determine what type of data it is. Excel recognizes
three specific types of data: labels (or text),
values (or numbers), and formulas (or equations).
Formulas are introduced in Chapter 2, “Working
with Formulas,” so for now you’ll spend time
learning the differences between labels and
Entering Data into a Cell
Regardless of the type of data you want
to enter, all data is entered in Excel the
1. Select the cell in which you want to
2. Type the information you want into
3. Press Enter or Tab to accept your data
entry and move to the next cell.
Perhaps you are creating a spreadsheet that
details the number of days in each month of the
year, as in Figure 1-12. The month names are
labels, the days are values, and the total number
of days is calculated by Excel using a formula.
Labels can also be thought of as information
about the numerical data in Excel. Excel assumes
that any data containing letters is a label and will
format it accordingly. Labels are left-aligned in the
cell, and cannot be calculated using a formula.
All About Cell Width
By default, the standard width of a cell is
8.43. According to Microsoft, this means
that 8.43 characters will ﬁt into the cell. If
your label has more than 8.43 characters,
Excel automatically extends the data you
typed beyond the cell’s right border. You will
learn how to resize the cells in Chapter 5,
“Making the Worksheet Look Good.”
A spreadsheet that includes labels,
values, and a formula.