The Excel Formula Wizard is a very useful tool for entering formulae with many arguments, or when the user is unfamiliar with the formula.
The Excel user can start the Formula Wizard by clicking on the Formula Wizard tool, shown above, or by typing the name of the function into a cell and then pressing Ctrl+A.
The first page of the wizard shows all the available worksheet functions, listed by category.
The second page of the wizard (also called the Formula Palette) contains fields for each of the function's arguments. Note that the description for the currently selected argument is displayed below the function's description.
From the developer's point of view, the most interesting aspect of the Formula Wizard is the preview result that appears in the palette, as shown below.
