Using the Insert Function Feature

Functions are built-in calculations that are used in formulas. A function begins with an equal sign and is followed by the name of the function, an opening parenthesis, the arguments of the formula, and a closing parenthesis. Click the Insert Function button to select the function you want to use and enter your arguments.

To add a function to a formula:

  1. Click the cell in which you want to enter the formula.
  2. Click the Insert Function button.
  3. Click the function you want to use.
  4. Enter the arguments.
  5. Click OK.


In the Insert Function dialog box, Excel has organized all the functions into categories so you can easily find the specific function you need based on the type of calculation it is. Excel also stores the most recently used functions in a separate category.

Arguments are the values the function uses to perform the calculation. Arguments vary depending on the function you are using, but typically include text, numbers, cell references and names.

  • You can also open the Insert Function box by selecting Function... from the Insert menu.
  • Use the AutoSum button arrow to quickly add a simple function to your workbook.