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

Sneak Peek




                Creating Cell Reference to Other Worksheet in Microsoft Excel:
                 .   eference to an Individual  ell:
                  Syntax:     Sheet name  ell address
                  Example:   o refer to cell    in Sheet   type  Sheet

                 .   eference to a  ange of  ells:
                  Syntax:   Sheet name First cell: ast cell
                  Example:   o refer to cells    :     in Sheet   type  Sheet    :





                                          Lab Assignment ‘n Activity                            I nte r - D is cip l inar y




              et us consider a workbook which contains marks of different students stored in different
             worksheets.












                Rename the worksheet as ‘Aniket’.
                Insert a new worksheet and name it as   unal .
                Insert marks secured by  unal.       in  nglish    5  in  indi       in Maths       in Science and
                     in Social Studies .

                Insert a worksheet and name it as   onsMarks  which contains total marks obtained by each
                student along with their names.  se  ell  eferencing method to display  otal.






















                Save the workbook.  Name the workbook as   eport ard





         182       Touchpad Information Technology-X
   179   180   181   182   183   184   185   186   187   188   189