Page 29 - Digicode_AI_class_6
P. 29

The exclamation point separates the worksheet portion of the reference from the cell portion.

            Other Workbook References

            You can refer to cells in a worksheet in other workbooks in the same way you refer to cells
            in other worksheets within the same workbook. These references are called external references.
            For example, to enter a reference to Book2 in Book1, follow the given steps:

             Step 1   Create two workbooks named Book1 and Book2.
             Step 2   Select cell A1 in Sheet1 of Book1, and type an equal (=) sign.

             Step 3    Switch  to  Book2  by  pressing  the  Alt+Tab  keys  on  the  keyboard.  Click  to  select
                      cell A2.

             Step 4   Press the Enter key.
                      After you press the Enter key, your formula in Book1, Cell A1, should be
                      = [Book2] Sheet1! $A$2.

            This reference has 3 parts:

            1.  The workbook Book2 in square brackets.
            2.  The worksheet Sheet1 followed by ! sign.
            3.  The cell having absolute reference.

            Hence,  referencing  cells  in  the  external  workbooks  is  done  by  selecting  the  workbook,  then  the
            worksheet, and then the cell you want to link reference to.

            Customise Worksheet Tab

            To customise the worksheet tab, follow the given steps:


                                                                               2  Click on  the  Rename to
                                                                               rename  the  sheet,  or  Tab
                                                                               Color to select a tab colour.






                                                                                3  Type in the name or
                                                                               select a colour you would
                                                                               like for your sheet.



              1  Right-click
              the sheet tab
              that you want
              to customise.


            The name or colour of the sheet will be changed.

            You can also use the Insert, Delete, and Move or Copy options to add a new sheet, delete a sheet,
            and move or copy a sheet, respectively.

                                                                         Formulas and Functions in Excel  27
   24   25   26   27   28   29   30   31   32   33   34