Page 185 - CA_165_V2.0_C9_Flipbook
P. 185

NF: Add Decimal   Increase
                                                                  Align Right          Place     Indent
                   Styles 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  NF: Delete
                                                                Horizontally            Decimal Place
                 Formula Bar

                 Formula Bar lies below the formatting toolbar. Formula that perform different calculations in cells are
                 entered and displayed here. It is denoted by fx.
                 Active Cell

                 The selected or activated cell is referred to as the active cell which is always highlighted with a thick
                 border. The address of the active cell is displayed in the name box for example, A1.
                 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 sheets appear in the sheet tabs at the
                 bottom of the spreadsheet. We can click on the specific sheet tab to open it.
                 Horizontal Scroll Bar

                 It lies below the sheet tabs. It helps to view the spreadsheet screen by moving the scroll button from
                 left to right and vice-versa.
                 Vertical Scroll Bar

                 It lies towards the right side of the spreadsheet. It helps to view the spreadsheet 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 spreadsheet.
                 Based on which type of data is being stored, data can be classified into numeric, alphanumeric or text,
                 date/time and formula.
                                                                DATA







                               Numeric           Alphanumberic            Date/Time            Formula



                                                                                    Working with Spreadsheet     183
   180   181   182   183   184   185   186   187   188   189   190