Microsoft Office Tutorials and References

In Depth Information

**Directly Entering Formulas and Functions**

A1: 15

A2: 32

A7: 38

A8: 39

A9: 28

A10: 26

A11: 29

A12: 30

A13: 30

A14: 28

A15: 31

The formula in D5 is +(A1+A2) * MIN(A7:A15). This results in 1222, not 21.

Excel’s ability to show a list of functions based on spelling is called
Formula

AutoComplete.

Figure 2-15:

Completing

the

direct-inthe-cell

formula

entry.

You can turn Formula AutoComplete on or off in the Excel Options dialog box:

1. Click the File tab at the top left of the screen.

2. Click Options.

3.IntheExcelOptionsdialogbox,selecttheFormulastab.

4. In the Working with Formulas section, check or uncheck the Formula

AutoCompletecheckbox.

See Figure 2-16 for the check box’s placement.

5. Click the OK button.