OpenOffice.org OpenOffice - 3.0 Quick Start Guide download pdf (Page 128)

100

101

Formula bar

On the left of the Formula bar (see Figure 95) is a small text box,

called the Name box, with a letter and number combination in it, such

. This is the column letter and row number, called the cell

reference, of the current cell.

Figure 95. Formula Bar

To the right of the Name box are the the Function Wizard, Sum, and

Function buttons.

Clicking the Function Wizard button opens a dialog from which you

can search through a list of available functions, what variables each

function takes and the result of the function with the given input .

The Sum button inserts a formula into the current cell that totals the

numbers in the cells above, or to the left if there are no numbers

above, the current cell.

The Function button inserts an equals sign into the selected cell and

the Input Line, thereby setting the cell ready to accept a formula.

When you enter new data into a cell, the Sum and Equals buttons

change to Cancel and Accept buttons .

The contents of the current cell (data, formula, or function) are

displayed in the Input Line, the remainder of the Formula bar. You can

edit the cell contents of the current cell here, or you can do that in the

current cell. To edit inside the Input Line area, click the appropriate

part of the Input Line area, then type your changes. To edit within the

current cell, just double-click the cell.

Individual cells

The main section of the screen displays the individual cells in the form

of a grid, with each cell being at the intersection of a particular column

and row.

128 Getting Started with OpenOffice.org 3

Name box

Function Wizard

Sum Button

Function Button

1 2 ... 123 124 125 126 127 128 129 130 131 132 133 ... 432 433

Comments to this Manuals

No comments

OpenOffice.org OpenOffice - 3.0 Quick Start Guide Page 128

Comments to this Manuals

Related products and manuals for Graphics software OpenOffice.org OpenOffice - 3.0