Calc Guide

Figure 138: Function List docked to right side of Calc window
Function Wizard
The most commonly used input method is the Function Wizard (Figure
139). To open the Function Wizard, choose Insert > Function, or click
the fx button on the Function tool bar, or press Ctrl+F2. Once open,
the Function Wizard provides the same help features as the Function
List, but adds fields in which you can see the result of a completed
function, as well as the result of any larger formula of which it is part.
Select a category of functions to shorten the list, then scroll down
through the named functions and select the required one. When you
select a function its description appears on the right-hand side of the
dialog. Double-click on the required function.
The Wizard now displays an area to the right where you can enter data
manually in text boxes or click the Shrink button to shrink the
wizard so you can select cells from the worksheet.
Figure 139: Function Wizard after shrinking
200 OpenOffice.org 3.x Calc Guide