Page 171 - CA 165 ver 1.0 Class 9
P. 171

l    It allows the formulae used to perform calculations to change automatically, when the corresponding
                      data values change.

                      Do you know?

                      ‘VisiCalc’ was the first spreadsheet package that was introduced in 1978. Later, ‘Lotus 1-2-3’, ‘Quattro
                      Pro’, ‘Excel’, ‘Calc’, etc. also emerged as famous spreadsheet packages.



                   INTRODUCING CALC

                 MS  Excel,  Google  Sheets  and  OpenOffice  Calc  are  the  most  popular  and  widely  used  spreadsheet
                 packages. OpenOffice Calc has been developed by Sun Microsystems. It is available free of cost and can
                 be easily downloaded from www.openoffice.org.

                 To begin with Calc in Windows, double click on its icon on the desktop or in ‘Linux’, click on OpenOffice
                 Calc from ‘Panel’.
                 ‘Calc’ opens a blank workbook as shown below:
                                                                                                         Close
                                                                                                         Maximize/
                     Menu Bar                                                                             Resotre
                                                                                                         Minimize
                     Name Box
                   Cell Pointer                                                                          Title Bar
                                                                                                         Standard
                    Formatting                                                                           Tool Bar
                     Tool Bar                                                                            Formula Bar
                          Cell

                                                                                                         Vertical
                                                                                                        Scroll Bar
                         Row


                                                                                                         Column

                     Sheet Tabs                                                                         Horizontal
                                                                                                         Scroll Bar
                                                                         Status Bar

                 Workbook And Worksheet
                 Worksheet is the working area or page on the screen. A worksheet consists of rows and columns. A
                 workbook is a collection of multiple worksheets. (A workbook is like a book and the worksheet is like
                 a 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.

                 Cells

                 A rectangular box formed by the intersection of a row and a column is called a cell. Cell is the basic unit
                 of a worksheet where data (numbers, text, formulas, etc.) are entered. A cell can be selected by clicking
                 on it. A selected cell is also called an active cell.


                                                                                    Working with Spreadsheet     169
   166   167   168   169   170   171   172   173   174   175   176