Microsoft Office Tutorials and References

In Depth Information

**Session 1.1**

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.

Using AutoComplete

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

order yet.

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.