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
   47   48   49   50   51   52   53   54   55   56   57