Page 204 - Trackpad 402_Class-X_Final
P. 204

OR
                Right-click on the Sheet tab and select Rename Sheet option.
                By using either of the above step will open the rename dialog box as shown below:
        Step 2:  Delete the old name shaded in blue and type a new name of your choice.
        Step 3:  Click on OK button.
















                CELL REFERENCE
        Cell reference is a very important feature of any spreadsheet program. A cell reference is the method used to refer to
        a cell or a range of cells in a worksheet. A cell is made up of a column name followed by a row number Cell reference
        of a single cell is Column name followed by the row number. For example, F10 means F column and row 10.
        Cell reference of a range of cells is starting cell address and ending cell address separated by colon(:) in between. For
        example, C10:C20, A1:B6 and C5:D10.

        The main advantage of using cell reference is that it can be used in formulas and functions. This helps you update
        the result of a function or a formula automatically if the value in a particular cell used in a formula changes. Also if a
        function or a formula is either copied or moved then the cell address in the formula/function is automatically updated
        with respect to the location it is copied or moved.

        The cell reference used in the formula or function can be taken:
        •  From different location in the same sheet. For example: D10, A1:C5
        •  From a different sheet but the same workbook: The reference has the sheet name(Sheet1) and the cell reference
          (A3) separated by dot(.) operator in between. For example:Sheet1.A3, Sheet2.C5:D8
        •  From a different workbook.

        Adding a Cell Reference Using a Mouse
        A cell reference of some other worksheet can be added easily using a mouse by following the given steps:
        Step 1:   Let us create a workbook with the name- ”POCKET MONEY.ods”. It has five sheets named as - JAN, FEB, MAR,
                APR, FIRST QUARTER SUMMARY with the following details:

                                                        Sheet: JAN





















          204   Trackpad Information Technology-X
   199   200   201   202   203   204   205   206   207   208   209