• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint

Using the Function Wizard

Although you can type a function directly into a cell just as you can type formulas, you'll find it easier to use the Function Wizard. The Function Wizard leads you through the process of inserting a function. The following steps walk you through using the Function Wizard:

  1. Select the cell in which you want to insert the function. (You can insert a function by itself or as part of a formula.)

  2. Type = or click the Edit Formula button on the Formula bar. The Formula Palette appears, as shown in Figure 20.2.

  3. Select the function you want to insert from the Functions list by clicking the arrow on the Functions drop-down list (see Figure 20.2). If you don't see your function listed, select More Functions at the bottom of the list.

  4. Enter the arguments for the formula. If you want to select a range of cells as an argument, click the Collapse Dialog button shown in Figure 20.2.

  5. After selecting a range, click the Collapse Dialog button again to return to the Formula Palette.

  6. Click OK. Excel inserts the function and argument in the selected cell and displays the result.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint