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
to display an alphabetical list of the AV functions.
Search JabSto ::

Custom Search