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

