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

NF: Add Deci-  Increase
                                                                 Align Right         mal Places  Indent
                   Style and                                              Merge             Decrease   Background
                  Formatting  Font Name      Font Size  Italic  Align Left  Cells  NF: Percent  Indent   Color




                                                   Bold  Underline   Justified   NF: Standard       Borders  Font Color
                                                              Align Center  NF: Currency  Delete Decimal
                                                                                          Places
                 Formula Bar

                 ‘Formula Bar’ lies below the formatting toolbar. It displays the content of the active cell. Formula that
                 perform different calculations in cells are entered and displayed here. It is denoted by ‘fx’.
                 Cell Pointer

                 The active cell in a worksheet is highlighted with a thick boundary called the Cell Pointer.
                 Cell Address
                 Each cell has a unique address which identifies its location. A cell address is identified with its column
                 position  followed  by  its  row  number,  for  example:  ‘A5’  is  the  cell  address  that  is  a  combination  of
                 column ‘A’ and row ‘5’.
                 Name Box

                 It lies besides the Formula Bar. It contains the address of the current cell or active cell.
                 Status Bar

                 It lies at the bottom of the screen. It shows the current status of an active application.
                 Sheet Tabs

                 It lies below the active sheet of the screen. The names of the worksheets appear in the sheet tabs at the
                 bottom of the workbook. We can click on the specific sheet tab to open it.
                 Horizontal Scroll Bar

                 It lies below the worksheet at the right side of the ‘Sheet’ tabs. It helps to view the worksheet screen by
                 moving the scroll button from left to right and vice-versa.
                 Vertical Scroll Bar
                 It lies towards the right side of the worksheet. It helps to view the worksheet by moving the scroll
                 button from top to bottom and vice-versa.

                   TYPES OF DATA

                 To begin working with a Spreadsheet Package, the user has to feed or enter data in a worksheet. Based
                 on which type of data is being stored, data can be classified into numeric, alpha-numeric or text, date/
                 time and formula.
                                                                DATA







                               Numeric           Alphanumberic            Date/Time            Formula





                                                                                    Working with Spreadsheet     171
   168   169   170   171   172   173   174   175   176   177   178