Microsoft Office Tutorials and References

In Depth Information

**Function Reference Chapters**

arguments. The examples are designed to give you ideas of how to use the func-

tions in real life.

Function coverage is broken out as follows:

•
Chapter 11
describes functions that many people encounter in their

everyday life: some of the math functions, date functions, and text

functions.

•
Chapter 12
describes functions that are a bit more difficult but that

should be a part of your everyday arsenal. These include a series of

functions for making decisions in a formula. They include the IF func-

tion and are known collectively as the logical functions.
Chapter 12

also describes the information, lookup, and database functions.

functions. The first section of the chapter includes functions that

anyone can use to calculate a car loan or plan for retirement. The

later sections of the chapter include functions for depreciation,

business valuation, and bond investing.

functions. Many of these functions are functions that are useful

everyday
—
for example, AVERAGE(), MAX(), MIN(), and RANK(). The

chapter also describes many highly specialized functions that are

useful to scientists and engineers.

•
Chapter 15
describes trigonometry and engineering functions. The tri-

gonometry functions are grouped along with the other math functions

in the Math Functions icon, but they are described separately in this

book because they are more specialized. The engineering functions are

highly specialized.