Microsoft Office Tutorials and References
In Depth Information
Chapter 2: Saving Time with Function Tools
Chapter 2
Saving Time with Function Tools
In This Chapter
Displaying the Insert Function dialog box
Finding the function you need
Using functions that don’t take arguments
Getting help with functions
Using the Function Arguments dialog box
Excel has so many functions that it’s both a blessing and a curse. You can
do many things with Excel functions — if you can remember them all!
Even if you remember many function names, memorizing all the arguments
the functions can use is a challenge.
Arguments are pieces of information that functions use to calculate and return
a value.
Never fear: Microsoft hasn’t left you in the dark with figuring out which
arguments to use. Excel has a great utility to help insert functions, and their
arguments, into your worksheet. This makes it a snap to find and use the
functions you need. You can save both time and headaches, and make fewer
errors to boot — so read on!
Getting Familiar with the Insert
Function Dialog Box
The Insert Function dialog box (shown in Figure 2-1) is designed to simplify
the task of using functions in your worksheet. The dialog box not only helps
you locate the proper function for the task at hand but also provides
information about the arguments that the function takes. If you use the Insert
 
Search JabSto ::




Custom Search