Using the Insert Function button in Excel

Insert Function dialog box

In addition to the five functions discussed in the previous posts, there are many other pre-defined functions available to you in Excel – financial functions, logical functions, date and time functions and statistical functions, just to name a few of the available categories.

To access Excel’s pre-defined functions, click the Insert Function Button, located to the left of the Formula Bar or on the Formulas Ribbon. The Insert Function dialog box allows you to choose from a wide array of handy functions.

Once you have chosen the desired function, the Function Arguments dialog box opens, prompting you for each required (or optional) argument. You can type the cell address directly into the argument boxes or you can click the Collapse Dialog Box button and select the cell or cell range to be included in the arguments.

To Enter a Function Using the Insert Function Feature

1. Click the Insert Function Button to the left of the Formula Bar
   Or
   Click the Insert Function Button on the Formulas Ribbon.
   Or
   Click the arrow on the AutoSum button and select More Functions.
   Or
   Press the Shift + F3 keystroke combination.
2. Select a Function Category from the Category combo box.
3. Select a function from the Select a Function list box.
4. Click the Collapse Dialog Box button to select the cell or cell range for the arguments (or type in the arguments manually in the argument text boxes).
5. Click the Display Dialog Box to return back to the Function Arguments dialog box.
6. Click OK.

Similar Posts:

• Understanding Date/Time Functions in Excel
• Using the VLOOKUP Function in Excel
• Using the PMT Function in Excel 2007
• Using a Named Range in Excel
• Entering in Functions Manually in Excel
• Using the AutoSum Button in Excel
• Using the Min, Max, Count and Average Functions in Excel

Tagged as: Excel Tips, Microsoft Office Tips