Page 23 - iPlus_Ver_2.0_class_8
P. 23

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.

                  i +  CUSTOMISE WORKSHEET TAB

                 To customise the worksheet tab, follow the given steps:



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



                    1  Right-click                                                  3   Type  in the  name  or
                    the sheet tab                                                  select a colour you would
                    that you want                                                  like for your sheet.
                    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.


                  i +  FUNCTIONS
                 Functions are predefined formulas in Excel to perform both simple and complex calculations.
                 They accept arguments and return values. Arguments are input given to the functions. These
                 arguments can be numbers or text. The values should be given in between the opening and
                 closing ( ) parenthesis.




                                                                                                                  21
                                                                              Spreadsheet—Functions and Charts
   18   19   20   21   22   23   24   25   26   27   28