Using the Insert Function Dialog Box and Formula Palette

Excel's Insert Function dialog box and Formula palette make it easier for you to use and understand functions by organizing them into logical categories and by prompting you to complete the arguments required to make the function return a correct value.

The Insert Function dialog box and Formula palette can be accessed in several ways:

  • Click the Insert Function button (the fx button)) on the Formula bar.

  • Click Insert in the menu bar and choose Insert Function.

  • Press Shift+F3.

  • Type the equal sign (=) and name of the function in a cell and press Ctrl+A. Then enter the arguments in the Function Arguments dialog box.

  • Click the Function down arrow button at the far left end of the Formula bar and ...

Get Sams Teach Yourself Microsoft® Office Excel 2003 in 24 Hours now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.