Windows XP Registry: A Complete Guide to Customizing and Optimizing Windows XP (Information Technologies Master Series)

Chapter 7. Using Excel Functions

While creating a formula provides mathematical calculations, Excel includes a much more powerful feature called functions. Functions are basically a fast way to enter a complex formula. Excel has over 230 different functions you can use, and it groups them together by categories such as mathematical, statistical, logical, or date and time. Using functions can save considerable room in the Formula bar and cuts down on typographical errors that are so easy to make when typing formulas.

In this chapter, you'll learn how to:

• Understand function requirements

• Use the SUM function and AutoSum button

• Work with numerical functions

• Create statistical, date, and logical functions