Page 183 - CA_165_V2.0_C9_Flipbook
P. 183

l    It allows the formulae used for calculations to update automatically when the corresponding data
                      values change.

                      Do you know?

                      VisiCalc was the first spreadsheet package that was introduced in 1979. 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  was  originally  developed  by  Sun  Microsystems  but  is  now  maintained
                 by The Apache Software Foundation. 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 the ‘Applications’ menu.
                 Calc opens a blank spreadsheet as shown below:
                                                                                                        Close
                    Menu Bar                                                                             Maximize/
                                                                                                        Restore Down
                    Name Box                                                                            Minimize
                   Active Cell                                                                          Title Bar
                                                                                                        Standard
                                                                                                        Toolbar
                   Formatting
                    Toolbar                                                                             Formula Bar
                                                                                                        Vertical
                         Cell                                                                          Scroll Bar


                         Row
                                                                                                        Column

                    Sheet Tabs                                                                          Horizontal
                                                                                                        Scroll Bar
                                                                        Status Bar
                 Spreadsheet and Sheet

                 A spreadsheet consists of sheets. Sheet is the working area or page on the screen. A Spreadsheet
                 consists of rows and columns. (A Spreadsheet is like a book and sheet is like a page of a book). By
                 default, a spreadsheet opens with three sheets, 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 at the bottom of the spreadsheet. 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 spreadsheet where data (numbers, text, formulas, etc.) are entered. A cell can be selected by
                 clicking on it, and the selected cell is referred to as the active cell.





                                                                                    Working with Spreadsheet     181
   178   179   180   181   182   183   184   185   186   187   188