Page 52 - Web Applications (803) Class 12
P. 52
Getting Started with Calc
Once you install OpenOffice (www.openoffice.org), open Calc and you will see a screen as follows:
Menu Bar Formula Bar Tool Bar
Name Box
Selected Cell
A worksheet with cells arranged in rows and columns is seen in the spreadsheet. We have entered some sample data in the
preceding worksheet for better understanding. Let us now learn about the components of OpenOffice Calc window:
1. A row is a horizontal (sleeping) arrangement of cells. All math marks are on row number 4, as shown above. They
are numbered from top to bottom along the left edge of the worksheet. There are 10,48,576 rows in a worksheet of
Calc.
2. A column is a vertical (standing) arrangement of cells. Mamta’s marks are in column B, as illustrated above. Columns
are labelled from left to right. There are 1024 columns available in Calc.
3. A cell is a rectangle-shaped box formed by the intersection of a row and column. In a cell, you can type text,
numbers, dates, formulas, and so on. The highlighted cell is the one that has been chosen. The selected cell in the
Figure is D2, the cell in column D on row 2, and it contains Shweta’s English marks.
4. Each cell has a unique address that identifies its location. A cell address is identified with its column position
followed by its row number. For example, ‘A5’ is the cell address that is a combination of column ‘A’ and row ‘5’.
5. Each cell has a unique address that identifies its location. A cell address is identified with its column position
followed by its row number. For example, ‘A5’ is the cell address that is a combination of column ‘A’ and row ‘5’.
6. Whatever you input, it appears in the formula bar, as shown. You can also immediately input or change data and
formulas in the Formula Bar.
7. The location of the selected cell is displayed in the name box. The cell’s location is a combination of column and
row. For instance, B5, where B denotes the column name and 5 denotes the row number.
8. A worksheet is the working area or page on the screen. A worksheet consists of rows and columns. A collection
of worksheets is known as a workbook. (A workbook is like a book and worksheet is like the page of a book). By
default, a workbook opens with three worksheets, namely Sheet1, Sheet2 and Sheet3. User can change the name of
the sheets and may delete or add extra sheets if required. The name of each sheet appears in the sheet tab towards
the bottom of the worksheet. The active sheet i.e. the sheet being used, is highlighted. In the above figure, Sheet1
is the active worksheet.
50 Touchpad Web Applications-XII

