Microsoft® Office Excel 2003 Inside Out

Inserting Functions

The easiest way to locate and insert built-in functions is by clicking the Insert Function button. When you do, the dialog box shown in Figure 13-5 appears.

If you're not sure what function you need, enter a description of what you are trying to do into the Search box. For example, if you enter "I want to know how many cells contain values" and then press Go, the Insert Function dialog box returns a list of recommended functions, similar to the list shown in Figure 13-6. As it turns out, the first function in the list of suggestions fills the bill. If you don't find the function you're looking for, try rewording your query.

Figure 13-6. Ask ...