Microsoft Office Tutorials and References
In Depth Information
Entering Text, Numbers, and Dates
Entering Text, Numbers, and Dates
Worksheet cells can contain text, numbers, or dates and times. Text data is any
combination of letters, numbers, and symbols that form words and sentences. Text data is often
referred to as a text string because it contains a string of text characters. Number data is
any numerical value that can be used in a mathematical calculation. Date and time data
are commonly recognized formats for date and time values. For example, Excel interprets
the cell entry April 15, 2013 as a date and not as text. By default, text is left-aligned in
cells, whereas numbers, dates, and times are right-aligned.
Entering Text
New data values are placed into the cell that is currently active in the worksheet. As you
enter data, the entry appears in both the active cell and the formula bar. Amanda wants
you to enter some of the information from the planning analysis sheet into the fi rst sheet
of the workbook. This worksheet will document the workbook’s purpose and content.
To enter the text for the documentation sheet:
1. Press the Ctrl+Home keys to make cell A1 the active cell on the Sheet1
worksheet, if necessary.
2. Type RipCity Digital Customer Orders in cell A1. As you type, the text appears
both in cell A1 and in the formula bar.
3. Press the Enter key twice. Excel enters the text into cell A1 and moves the active
cell down two cells to cell A3.
4. Type Author in cell A3, and then press the Tab key. The text is entered and the
active cell moves one cell to the right to cell B3.
5. Type your name in cell B3, and then press the Enter key. The text is entered and
the active cell moves one cell down and to the left to cell A4.
6. Type Date in cell A4, and then press the Tab key. The text is entered and the
active cell moves one cell to the right to cell B4, where you would enter the date
you created the worksheet. For now, you’ll leave the cell for the date blank.
7. Click cell to make it the active cell, type Purpose in the cell, and then press A5
the Tab key. The active cell moves one cell to the right to cell B5.
8. Type To record orders from RipCity Digital customers in cell B5, and then
press the Enter key. Figure 1-4 shows the text entered in the Sheet1 worksheet.
Figure 1-4
Documentation sheet
your name appears here
text t hat doesn’t fit within a cell
covers the cell(s) to the right
Search JabSto ::




Custom Search