Microsoft Office Tutorials and References
In Depth Information
You can also enter formulas interactively by clicking each cell. In this technique, you
type = (an equal sign) to begin the formula, and then click each cell that needs to be
entered in the formula. Using this point-and-click method reduces the possibility of error
caused by typing an incorrect cell reference.
Next, you’ll enter the data for the second order, and then enter the formula =E3*F3 (the
price of the item multiplied by the quantity ordered) using the point-and-click method.
To enter the same formula using the point-and-click method:
1. Enter David Wu in cell A3, 315 Oak Lane on one line in cell B3 and Midtown , FL 80422
on a second line in the cell, 4/16/2006 in cell C3, Navel Oranges in cell D3, $17 in cell E3,
and 1 in cell F3. Be sure to press the Alt + Enter keys to enter the address information on
two separate lines as you did for the address in cell B2.
2. Make sure cell G3 is the active cell, and then type = (but do not press the Enter or Tab key).
When you type the equal sign, Excel knows that you are entering a formula. Any cell that
you click from now on will cause Excel to insert the reference of the selected cell into the
formula until you complete the formula by pressing the Enter or Tab key or by clicking the
Enter button on the Formula bar (refer to Figure 1-14).
3. Click cell E3 . Note that the cell is highlighted in the same color as the cell reference that
now appears in the formula in cell G3.
4. Type * to enter the multiplication operator.
5. Click cell F3 to enter this cell reference, and then press the Enter key. Cell G3 now contains
the formula =E3*F3 and displays the value $17, which is the total amount of the second order.
As you continue to work with Excel, you may find yourself entering the same text in differ-
ent rows in the worksheet. To help make entering repetitive text easier, Excel provides the
AutoComplete feature. Once you enter text in a worksheet, Excel tries to anticipate the
text you are about to enter by displaying text that begins with the same letter as a previous
entry. For example, two people—David Wu and Carl Ramirez—have ordered a box of
navel oranges. You have already entered the data for David Wu’s order. When you enter
the data for Carl Ramirez’s order, you will see how AutoComplete works.
To enter text using AutoComplete:
1. Enter Carl Ramirez in cell A4, 900 South Street Crawford , FL 81891 in cell B4 on two
separate lines within the cell, and 4/17/2006 in cell C4. Do not enter the item for Carl’s
2 . Make sure cell D4 is the active cell, and then type N . Note that Excel anticipates the entry by
displaying “Navel Oranges,” which is text you have already entered beginning with the letter N.
See Figure 1-15. At this point, you can accept Excel’s suggestion by pressing the Enter or Tab
key to complete the text entry and to exit the cell. To override Excel’s suggestion, you simply
keep typing the text you want to enter into the cell.