Page 52 - Artificial Intellegence_v2.0_Class_12
P. 52
Getting Started with Calc
Once you install OpenOffice .openoffice.org), open alc and you ill see a screen as follo s
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 orksheet for better understanding. et us no learn about the components of OpenOffice alc indo
1. A row is a hori ontal sleeping) arrangement of cells. All math marks are on ro number , as sho n above. hey
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. amta s marks are in column , as illustrated above. olumns
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
igure is D , the cell in column D on ro , and it contains h eta s nglish marks.
. ach cell has a unique address that identifies its location. A cell address is identified ith its column position
follo ed by its ro number. or e ample, A is the cell address that is a combination of column A and ro .
. ach cell has a unique address that identifies its location. A cell address is identified ith its column position
follo ed by its ro number. or e ample, A is the cell address that is a combination of column A and ro .
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. he 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 orkbook is like a book and orksheet is like the page of a book). y
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 orksheet. he active sheet i.e. the sheet being used, is highlighted. In the above figure, heet
is the active worksheet.
50 Touchpad Artificial Intelligence (Ver. 2.0)-XII

