Page 246 - open office
P. 246

It is used for  entering and editing the formula in the cell. Formula bar consists of:
                Name box: It displays the cell reference, for example A1 or D1 .

                Functions wizard: It consists of a list of available functions that we can search .
                Sum: It is used to find the total of the numbers in the cells above the selected cell. The sum is placed in the
                 selected active cell.
                Function: It lets you click on the Function icon and inserts an equals (=) sign into the selected cell.

                Input line: It displays the contents of the selected cell (data, formula, or function). It allows editing of the
                 cell contents. Click in the area and, then type the changes. To edit within the current cell, just double-click
                 in the cell.
              Cell Pointer

              The active cell in a worksheet is known as the Cell Pointer. It remains highlighted with bold border in the active
              worksheet.
              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. In a spreadsheet,
              active cell is the place where data is entered. Before entering any data in the cell, it has to be first selected by
              placing a cursor on it. Then, when we position the mouse cursor on a cell, it gets selected and is ready to take
              data from the user or perform editing.
              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 beside 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. 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 data. Data can be classified into numeric,
              alpha-numeric or text, date/time and formula.




               246      Touchpad Information Technology-IX
   241   242   243   244   245   246   247   248   249   250   251