Microsoft Office Tutorials and References

In Depth Information

**Directly Entering Formulas and Functions**

3. Add, edit, or delete arguments.

•Toaddanargument(ifthefunctionallows),usetheRefEditcontrol to pick up the extra values from the worksheet. Alternatively,

if you click in the bottom argument reference, a new box opens

below it into which you can enter a value or range.

•Toeditanargument,simplyclickintoitandchangeit.

•Todeleteanargument,clickintoitandbackspaceitout.

4. Click OK when you’re finished.

The function is updated with your changes.

Directly Entering Formulas

and Functions

As you get sharp with functions, you will likely bypass the Insert Function

dialog box altogether and enter functions directly. One place you can do this

is in the Formula Bar. Another way is to just type into a cell.

Entering formulas and functions

in the Formula Bar

When you place your entry in the Formula Bar, the entry is really going into

the active cell. However, since the active cell can be anywhere, you may

prefer entering formulas and functions directly in the Formula Bar. That way

you know that the entry will land where you need it. Prior to entering a

formula in the Formula Box (on the right side of the Formula Bar), the Name Box

on the left lets you know where the entry will end up. The cell receiving the

entry may be not be in the visible area of the worksheet. Gosh, it could be

a million rows down and thousands of columns to the right! After you start

entering the formula, the Name Box becomes a drop-down list of functions.

This is useful for nesting functions. As you enter a function in the Formula

Box, you can click on a function in the Name Box and the function is inserted

into the entry you started in the Formula Box. Confused? Imagine what I went

through explaining that! Seriously though, this is a helpful way to assemble

nested functions. Try it, get used to it; it will add to your Excel smarts.