O'Reilly logo

2007 Microsoft® Office System Inside Out by Microsoft Corporation

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Inserting Functions

Inserting Functions

The easiest way to locate and insert built-in functions is by clicking the Insert Function button. This button has two versions—one is the little fx button that appears on the formula bar, and the other is located in the Function Library group on the Formulas tab on the Ribbon. Either way, when you click Insert Function, the dialog box shown in Figure 14-2 appears. If you’re not sure what function you need, type a description of what you are trying to do in the Search text box. For example, if you type how many cells contain values and then click the Go button, the Insert Function dialog box returns a list of recommended functions, ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required