Microsoft Office Tutorials and References

In Depth Information

**Function Categories**

See subsequent chapters for specific examples of using the functions.

Financial functions

The financial functions enable you to perform common business calculations that deal with

money. For example, you can use the PMT function to calculate the monthly payment for a car

loan. (You need to provide the loan amount, interest rate, and loan term as arguments.)

Date and time functions

The functions in this category enable you to analyze and work with date and time values in

formulas. For example, the TODAY function returns the current date (as stored in the system clock).

Math and trig functions

This category contains a wide variety of functions that perform mathematical and trigonometric

calculations.

The trigonometric functions all assume radians for angles (not degrees). Use the

RADIANS function to convert degrees to radians.

Statistical functions

The functions in this category perform statistical analysis on ranges of data. For example, you can

calculate statistics such as mean, mode, standard deviation, and variance. Excel 2010 includes

many new functions in this category.

Lookup and reference functions

Functions in this category are used to find (look up) values in lists or tables. A common example

is a tax table. You can use the VLOOKUP function to determine a tax rate for a particular income

level.

Database functions

Functions in this category are useful when you need to summarize data in a list (also known as a

worksheet database) that meets specific criteria. For example, assume you have a list that

contains monthly sales information. You can use the DCOUNT function to count the number of

records that describe sales in the Northern region with a value greater than 10,000.