Advertisement
Online Test Banks
Score higher
See Online Test Banks
eLearning
Learning anything is easy
Browse Online Courses
Mobile Apps
Learning on the go
Explore Mobile Apps
Dummies Store
Shop for books and more
Start Shopping

How to Build Excel 2007 Formulas with the Insert Function Dialog Box

The Insert Function dialog box in Excel 2007 is designed to simplify the task of using functions in your worksheets. 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 Function dialog box, you don’t have to type functions directly into worksheet cells. Instead, the dialog box guides you through a (mostly) point-and-click procedure.

Arguments are pieces of information that functions use to calculate and return a value.

1

Display the Insert Function dialog box.

The most common ways to do this are by clicking the Insert Function button on the Formulas tab or by clicking the Insert Function button on the Formula Bar (which looks like fx). You can also access the Insert Function dialog box by clicking the small arrow at the bottom of the AutoSum button on the Formulas tab of the Ribbon and selecting More Functions.

2

Select the desired function in the Select a Function list box.

A description of the selected function, along with the function syntax, appears at the bottom of the dialog box.

3

Click OK.

The Insert Function dialog box closes and the Function Arguments dialog box appears. This is where you enter or select the arguments for the function. Click the Help on This Function link at the bottom of the dialog box for more details on the function.

4

Enter the function arguments and click OK.

Click Cancel if you want to return to the worksheet without entering a function.

Another way to access functions is directly from the Function Library on the Formulas tab of the Ribbon. Click the button representing the category of function you want (such as Financial) and select the desired function.

blog comments powered by Disqus
Advertisement
Advertisement

Inside Dummies.com

Dummies.com Sweepstakes

Win an iPad Mini. Enter to win now!