Calc Open Office Part I

What is Calc?

• Calc is the spreadsheet component of OpenOffice
• You can enter data, usually numerical data, in a spreadsheet and then manipulate this data to produce certain results.

Spreadsheets, sheets and cells

• Calc works with elements called spreadsheets.
• Spreadsheets consist of a number of individual sheets, each containing a block of cells arranged in rows and columns.
• These cells hold the individual elements
•  e.g. text, numbers, formulas etc.
• Each spreadsheet can have many sheets and  each sheet can have many individual cells.

Starting Open Office Writer

Start>>>All Programs>>>OpenOffice 4.0.1>>>OpenOffice Calc

Parts of the main Calc window

Navigating within spreadsheets

•  Using the mouse and keyboard

                 Place the mouse pointer over the cell and left-click. And using the keyboard you can use                      arrow keys,shift and tab keys to move.

•  Using a cell reference

                       Type the cell reference of the cell you want to go to at the active cell indicator text box                       and press Enter.

• Using the Navigator

         Click on the Navigator button in the Standard toolbar and get the navigator window. Type the               cell reference into the top two fields, labeled Column and Row, and press Enter.

Inserting columns and rows

Method 1 : Using the Insert menu

1. Select the column or rows where you want the new column or row inserted.
2. Select either Insert > Columns or Insert > Rows.

Note: When you insert a single new column, it is inserted to the left of the highlighted column.

         When you insert a new row, it is inserted above the highlighted row.

Deleting columns and rows

Select the column/s > Right-click > Delete Columns

Select the row/s > Right-click > Delete Rows

Deleting Data

Removing text only

• The text alone can be removed from a cell without removing any of the formatting of the cell, by pressing the Backspace key.

Removing text and formatting

• The text and the formatting can be removed from a cell at the same time. Pressing the Delete key brings up a Delete Contents dialog box.