Page 178 - IT 402 v2.0 class 10
P. 178

Renaming Worksheets

         t the bottom of each worksheet window  there are small   abs  that indicate the names of the worksheets
        in the workbook.  y default  their names are  Sheet     Sheet     Sheet   and so on.  hese names are not very
        descriptive.  enaming a worksheet as per its content gives a brief idea about the stored content. For instance
        if sales of different months by a salesman are stored in different worksheets  names of the sheets can be
        renamed by month names.

        To rename a worksheet:
        Step 1:   ouble-click on one of the existing worksheet names.

                  ename Sheet  dialog box appears on the screen.

        Step 2:   ype the desired name of the worksheet
        Step 3:   lick on  O   button.









                                                                              3
                     2










                      1






                                        Renamed
                                        Worksheet


           CELL REFERENCE

         hile doing calculations or summarising data in spreadsheet  we often find ourselves in a situation to fetch
        data from other worksheets or even from different workbooks.  his can be done by creating  ell  eference.
        In OpenO ce  alc  there are options to link different sheets and one can fetch data from different sheets
        based on a common field.
          cell reference refers to a cell or a range of cells on a worksheet that can be used to find the values or data.
         he main benefit of using a cell reference is when the data present in referenced cell s  in another worksheet
        changes  a value returned by the cell reference is automatically updated.

        Cell Reference refers to:
          Data from one or more contiguous cells on the worksheet

           ata contained in different areas of a worksheet
           ata on other worksheets in the same workbook



         176       Touchpad Information Technology-X
   173   174   175   176   177   178   179   180   181   182   183