Page 29 - Computer Genius Class 06
P. 29

The e clamation point separates the  or sheet portion o  the re erence  rom 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  or sheets  ithin the same  or  oo . These re erences are called external references.

                 For e ample  to enter a re erence 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 e ual     sign.
                 Step 3    Switch to  Book2  by pressing the  Alt+Tab   eys  on  the   ey oard.   lic   to  select
                           cell A2.

                 Step 4   Press the Enter  ey.
                           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  or  oo  Book2 in s uare  rac ets.

                 2.  The  or sheet Sheet1  ollo ed  y   sign.
                  .  The cell ha ing a solute re erence.
                  ence   re erencing  cells  in  the  e ternal   or  oo s  is  done   y  selecting  the   or  oo    then  the
                  or sheet  and then the cell you  ant to lin  re erence 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 ta  colour.






                                                                                    3  Type in the name or
                                                                                    select a colour you would
                                                                                    li e  or your sheet.



                   1   ight clic
                   the sheet tab
                   that you want
                   to customise.


                 The name or colour o  the sheet  ill  e changed.

                 You can also use the Insert, Delete, and Move or Copy options to add a new sheet, delete a sheet,
                 and mo e or copy a sheet  respecti ely.

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