Microsoft Office Tutorials and References
In Depth Information
amount of each order. The TOTAL row will display the total quantity of items ordered and
the total revenue generated by all of the sales. With this information in hand, you are now
ready to create Sandra’s worksheet in Excel.
Entering Data into a Worksheet
A worksheet can contain the following types of data: text, numeric values, dates, and cal-
culated values. A text entry is simply any combination of words, letters, and numbers, typ-
ically used to label key features of the worksheet. Numeric values are numbers on which
calculations can be made. Numeric values do not contain alphabetic characters, but may
contain characters such as commas, dollar signs, and percent signs. Dates are special
numeric values recognized by Excel and can be used to determine date-related calcula-
tions. The power of Excel lies in the formulas that you can enter into the worksheet cells,
whose calculated values are based on the text, dates, and numeric values entered into
other cells in the workbook (or in more complicated cases, other workbooks). If those val-
ues are changed, the calculated values will also be changed.
Worksheet cells in Excel can also be formatted to improve or enhance the appearance
of the cell contents or an entire worksheet. You’ll learn about formatting later in Tutorial 3.
To insert text into a worksheet cell, you first make the cell active by using one of the navi-
gation techniques discussed earlier, and then you type the text you want the cell to con-
tain. Excel automatically aligns the text with the left edge of the cell.
First, you’ll enter the column headings that Sandra wants across the top row of her
To enter the column headings in row 1:
1. Press the Ctrl + Home keys to make cell A1 the active cell on the Sheet1 worksheet.
2. Type Name and then press the Tab key. Pressing the Tab key enters the text in the cell and
moves the insertion point to the right to cell B1, making it the active cell.
3. Type Address in cell B1, and then press the Tab key again. Cell C1 becomes the active cell.
4. Enter the remaining column headings Date , Item , Price , Qty , and Total in cells C1
through G1. Press the Enter key after you type the text for cell G1. Figure 1-9 shows the
column headings for the worksheet.
Entering text into the worksheet
when you press the Enter key cell A2 becomes the active cell
Trouble? If you make a mistake as you type, you can correct the error by clicking the cell
and retyping the entry.