Microsoft Office Tutorials and References

In Depth Information

**Entering formulas manually**

continued

The completed formula is

=AGGREGATE(1,2,TestScores)

Formula AutoComplete includes the following items (and each type is identiﬁ ed by a separate icon):

■

Excel built-in functions

■

User-deﬁ ned functions (functions deﬁ ned by the user through VBA or other methods)

■

Deﬁ ned names (cells or range named using the Formulas

➪

Deﬁ ned Names

➪

Deﬁ ne Name

command)

■

Enumerated arguments that use a value to represent an option (only a few functions use

such arguments, and
AGGREGATE
is one of them)

■

Table structure references (used to identify portions of a table)

Entering formulas manually

Entering a formula manually involves, well, entering a formula manually. In a selected cell,

you simply type an equal sign (
=
) followed by the formula. As you type, the characters

appear in the cell and in the Formula bar. You can, of course, use all the normal editing

keys when entering a formula.

Entering formulas by pointing

Even though you can enter formulas by typing in the entire formula, Excel provides

another method of entering formulas that is generally easier, faster, and less error prone.

This method still involves some manual typing, but you can simply
point
to the cell

references instead of typing their values manually. For example, to enter the formula
=A1+A2

into cell A3, follow these steps:

1.
Move the cell pointer to cell A3.

2.
Type an equal sign (
) to begin the formula.
Notice that Excel displays
=
Enter
in

the status bar (lower left of your screen).

3.
Press the up arrow twice.
As you press this key, Excel displays a moving border

around cell A1, and the cell reference appears in cell A3 and in the Formula bar. In

addition, Excel displays
Point
in the status bar.

4.
Type a plus sign (
A solid color border replaces the faint border, and Enter
).

pears in the status bar.

5.
Press the up arrow again.
The moving border encompasses cell A2 and adds that

cell address to the formula.

6.
Press Enter to end the formula.