Page 29 - CG_v2.1_flipBooks_class_6
P. 29

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

                 You can use cell references to access cells in other workbooks in a similar manner as you would refer
                 to cells in different 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