Page 244 - open office
P. 244

Do you know?


                       isiCalc  was the first spreadsheet package that was introduced in 1   .  ater,   otus 1-2-3 ,   uattro
                     Pro’, ‘Excel’, ‘Calc’, etc. were also developed as spreadsheet packages.



               ibreOffice Calc, MS-Excel and OpenOffice Calc are the common spreadsheet packages that are used today.
              OpenOffice Calc has been developed by Sun Microsystems. It is available free of cost and can be easily
              downloaded from www.openoffice.org.
                PARTS OF A WORKBOOK SCREEN

              To open Calc in Windows, double-click on its icon on the desktop screen or in   inux , click on the OpenOffice
              Calc from ‘Panel’. ‘Calc’ opens with a blank workbook as:

                        Control                                                                        Close
                        Button
                                                                                                      Maximize/
                   Menu Bar                                                                            Restore
                    Name Box                                                                        Minimize
                      Active cell
                                                                                                     Title Bar

                Formatting Tool Bar                                                                   Standard
                                                                                                      Tool Bar
                      Sheet Tab                                                                       Formula Bar
                                                                                                             Vertical
                                                                                                            Scroll Bar

                       Sheet Tab                                                                             Horizontal
                                                                                                             Scroll Bar

               et us now learn about the various parts of a workbook screen.

              Workbook and Worksheet

              A workbook consists of worksheets. Worksheet is the working area or page on the screen. A worksheet
              consists of rows and columns. (A workbook is like a book and worksheet is like a page of a book). By default, a
              workbook opens with three worksheets namely Sheet1, Sheet2 and Sheet3. Users can change the name of the
              sheets and 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.

              Rows

              Rows are the set of rectangular boxes that are placed on top of each other in a horizontal position. They are

              numbered from top to bottom along the left edge of the worksheet. There are 1 ,4 ,5 6 rows in a worksheet
              of Calc.
              Columns

              Columns are the vertical set of rectangular boxes that are placed adjacent to each other. Columns are labelled

              from left to right. There are 1 24 columns available in Calc.





               244      Touchpad Information Technology-IX
   239   240   241   242   243   244   245   246   247   248   249