1.1
Table Of Contents
- Contents
- Overview
- What is Calc?
- Workbooks, worksheets and cells
- Parts of the main Calc window
- Starting new workbooks
- Opening existing workbooks
- Saving workbooks
- Navigating within worksheets
- Selecting items in a worksheet
- Inserting and deleting columns and rows
- Inserting and deleting worksheets
- Renaming worksheets
- Worksheet views
- Entering data into a worksheet
Parts of the main Calc window
Click the little button with an inverted triangle
to the right of the box to open a menu.
From the Load URL menu you can open a
new document. From the Font Name and
Font Size menus, you can change the font and
its size in selected cells.
Formula bar
On the left of the Formula bar (see Figure 4) is a small text box, called the Sheet Area box,
with a letter and number combination in it, such as D7. This is the column letter and row
number, called the cell reference, of the current cell.
Figure 4. Formula Bar
To the right of the Sheet Area box are the the Function AutoPilot, the Sum button, and the
Equals button.
Clicking the Function AutoPilot button opens a dialog box from which you can search
through a list of available functions. This can be very useful, because it also shows how the
functions are formatted.
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 Equals 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 that already contains something, 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, left-click the
appropriate part of the Input Line area, then type your changes. To edit within the current
cell, just double-click the current cell.
Getting Started with Calc 4
Figure 3. Load URL, Font Name, and Font Size
Load URL
Font
Name
Font
Size
Function
AutoPilot
Sum button
Equals button
Cell Reference