Microsoft Office Tutorials and References

In Depth Information

**Using AutoComplete to Find Functions**

established in Excel for a decade, and in some cases, functions are tucked

away in strange places.

For example, the SUM() function is a Math & Trig function. This makes sense

because adding numbers is clearly a mathematical process. However, the

AVERAGE() function is not available in the Math & Trig icon. (It is under More

Functions, Statistical.) The COUNT() function could be math, reference, or

information, but it is found under More Functions, Statistical.

By dividing the list of functions up into categories, Microsoft has made it

rather difficult to find certain functions. Fortunately, as described in the

following sections, you can use some tricks to make this process simpler.

Using AutoComplete to Find Functions

One feature in Excel 2013 is Formula AutoComplete. Sometimes you might re-

member the first letter of a function but not all the rest of the letters. For

example, there are five varieties of the function you use to do averages, and

they all start with A. Rather than trying to figure out whether the averaging

function you need is in the Math or Statistical icon, you can just start typ-

ing =AV

=AV in a cell. Excel displays a pop-up window with all the functions that

begin with AV, as shown in
Figure 10.3
.

Figure 10.3.

Figure 10.3.
Rather than use the icons on the Formulas tab, you can type

Rather than use the icons on the Formulas tab, you can type =AV

=AV

to display an alphabetical list of the AV functions.