Page 179 - IT 402 v2.0 class 10
P. 179

Creating Cell Reference to other Worksheets

             o create a reference for a cell or range of cells to another worksheet in the same workbook  write the name
            of worksheet followed by a dot mark  .  before the cell address. In other words  for creating cell reference to
            another worksheet  following format can be used:

            Reference to an Individual Cell
            Syntax: Sheet name. ell address
            Example: To refer to cell A1 in Sheet2, type ‘Sheet2.A1’

            Reference to a Range of Cells
            Syntax: Sheet name.First cell: ast cell
            Example:  o refer to cells   :    in Sheet   type  Sheet .  :

            In the following example  the worksheet function named         calculates the average value for the range
              :    created on the worksheet named  Marketing  in the same workbook.
                                                                 1        2

                                                  =AVERAGE(Marketing.B1:B10)

                                                                      3

               efers to the worksheet named  Marketing .

               ange of cells between    to      inclusively.
              Separates the worksheet reference from the cell range reference.
                      N ot e s

                                                          non-alphabetical
                                                        or
                                     name
                                          includes
                                                  spaces
                                                                                                   it
                                                                                                     in
                                                                                                       single
                                                                                            enclose
                                                                          characters
                                                                                   you
                                                                                       must
                           worksheet
                      If the worksheet name includes spaces or non-alphabetical characters  you must enclose it in single
                      If  If  the  worksheet  name  includes  spaces  or  non-alphabetical  characters   you  must  enclose  it  in  single
                        the

                                                                          in
                                                                   cell
                               marks.
                                                                                                 anuary
                                                                                                       Sales
                                                                                        named
                                                                             a
                                                                              worksheet
                                                                 to
                                          example
                                      For
                       uotation marks. For example  a cell reference to cell    in a worksheet named   anuary Sales
                                                  a
                                                        reference
                       uotation  marks.  For  example   a  cell   reference  to  cell      in  a  worksheet  named    anuary  Sales
                                                    cell
                       uotation
                      should be written in this format:   anuary Sales
                      should be written in this format:   anuary Sales
            Ways to create cell referencing to other sheets
             here are two ways to create cell reference to other sheets:
               y entering the formula directly using the keyboard
              By using the mouse
             etails about Sales of Stationery Items for the months of  anuary  February and March are maintained in
            different worksheets.
            Sales in January Month
                                                                       Advanced Features of Spreadsheet        177
   174   175   176   177   178   179   180   181   182   183   184