Microsoft Office Tutorials and References

In Depth Information

**Entering Functions Using the Insert Function Dialog Box**

Table 2-1

Function Categories in the Insert Function Dialog Box

Category

Type of Functions

Most Recently Used

The last several functions you used

All

The entire function list, sorted alphabetically

Financial

Functions for managing loans, analyzing investments, and

so forth

Date & Time

Functions for calculating days of the week, elapsed time,

and so forth

Math & Trig

A considerable number of mathematical functions

Statistical

Functions for using descriptive and inferential statistics

Lookup & Reference

Functions for obtaining facts about and data on worksheets

Database

Functions for selecting data in structured rows and columns

Text

Functions for manipulating and searching text values

Logical

Boolean functions (AND, OR, and so forth)

Information

Functions for getting facts about worksheet cells and the

data therein

User Defined

Any available custom functions created in VBA code or

from add-ins; this category may not be listed

Engineering

Engineering and some conversion functions. These

functions are also provided in the Analysis ToolPak

Cube

Functions used with online analytical processing (OLAP)

cubes

Compatibility

Some functions have been updated in Excel 2010 and Excel

2013. The functions in this category are the older versions

that remain compatible with older versions of Excel.

Web

A few functions that are useful when sharing data with

web services

Entering Functions Using the

Insert Function Dialog Box

Now that you’ve seen how to search for or select a function, it’s time to use

the Insert Function dialog box to actually insert a function. The dialog box

makes it easy to enter functions that take no arguments and functions that
do

take arguments. Either way, the dialog box guides you through the process of

entering the function.