119. Use the Function AutoPilot

 < Day Day Up > 

Calc's AutoPilot simplifies the task of creating complex formulas and functions with your spreadsheet data.

Before You Begin

118 About Calc Functions

Select Cell and Start AutoPilot

Select the cell that will contain the function. Then select the AutoPilot: Functions button on the Formula bar. The AutoPilot: Functions dialog box opens.

Select Function

In the AutoPilot dialog box use the Category drop-down list to select the function category you want to view. To select a function, use the Function scroll box. After you have selected your function, click Next.

Shrink AutoPilot

On the next AutoPilot screen you must provide the range of cells that you want the function to act on. The easiest way to specify the range is to shrink the AutoPilot. Select the Shrink button in the Number 1 range box on the right of the AutoPilot. The AutoPilot dialog box shrinks or rolls up, allowing you to view the data on the sheet.

Select Cell Range

Select the range of cells to be used in the function. Then press Enter. The AutoPilot dialog box reappears (unshrinks).

Enter Function

To enter the function in the cell, click OK. The function is placed in the cell, showing the results.


When you use some functions such as the AVERAGE function, you may want to decrease the number of decimal places shown in the functions results so that only "whole" numbers are represented. Use the Number Format: Delete Decimal Place button on the Object bar to reduce the number of decimal places shown in the function's results.


If the results of your function show as ####, this means that the column width can't accommodate the results of the function. Widen the column as needed to view the function results.

     < Day Day Up > 

    Novell Linux Desktop 9. User's Handbook
    Novell Linux Desktop 9 Users Handbook
    ISBN: 0672327295
    EAN: 2147483647
    Year: 2003
    Pages: 244
    Authors: Joe Habraken

    flylib.com © 2008-2017.
    If you may any questions please contact us: flylib@qtcs.net