Performing Basic Spreadsheet Tasks

Similar to any other spreadsheet application, Calc is used to process numerical information or text in tabular form. It is primarily used for tabulating numerical figures. It also allows you to sort and manipulate data, apply arithmetic, mathematic and statistical functions to data sets and represent the datasets in charts or graphical forms. The following sections describe the instructions to perform some basic spreadsheet tasks in Calc.

Formatting Tables and Cells

To format tables and cells in a Calc spreadsheet:

1. On the Applications menu, point to Office and then click OpenOffice.org Spreadsheet to open a Calc spreadsheet. A new Calc window opens.

Figure 5.24: Launching Calc 2. Some of the key components of the main Calc window are described below:
Figure 5.25: The Calc Window

• The Name box contains the cell and the row number, called the cell reference, of the current or active cell.

• The active cell indicates the selected cell currently in use.

• The Function wizard opens the Function Wizard dialogue box.

• The Sum button allows you to calculate the sum of the numbers in the cells that are above the current cell.

• Clicking the Function button inserts an equals sign into the current cell as well as in the input line, making it ready to accept a formula.

• The sheet tabs at the bottom of the sheet indicate the number of worksheets present in the current spreadsheet. By default, a new spreadsheet includes three worksheets.

3. After you have entered the required data in the spreadsheet, you can apply different formatting styles to it by selecting from the wide range of options available in Calc. To apply desired formatting to a selected range of cells, on the Format menu, click Cells. The Format Cells dialogue box opens.

File Edit View Insert Format Tools Data Window Help

File Edit View Insert Format Tools Data Window Help

iil'ûHâ

Default Formatting Ctrl+Shift+Space

Ï a • A1 * & -1 m 1 * - 1

»

Cells... Ctrl-l-l

il g

Uli * a st

[Arial

Row > Column ► Sheet ► Merge Cells ►

|A1:E1 M

A 1 B

Page...

F

G

H

1

-

1

H3J

-

2

Peter

Male

Print Ranges ►

3

Casey

Female

Change Case ► Styles and Formatting Fll li§ Auto Form at...

Conditional Formatting...

4

Fred

Male

5

Ralph

Male

6

Sue

Female

7

Pat

Male

8

Magan

Male

9

Mike

Male

10

Harold

Male

11

Henry

Male

i| Control...

12

Dan

Male

13

Kerry

Female

14

-ouis

Male

15

Jeff

Male

16

Melissa

Female

17

Heather

Female

18

Hayden

Female

IQ

Rach

Male

\Sheetl

/Sheet

1 M

Sheet 1/3

Deft

Sum=a

Was this article helpful?

0 0

Post a comment