Page 183 - IT_V1.0_Class10
P. 183
Name of the cell (A2).
5
Step 6: Press Enter key.
Referenced
Cell
21 st
Lab Assignment ‘n Activity Century #Technology Literacy
Skills
Complete the following activities and tick the circle.
Let us consider a spreadsheet which contains marks of different students stored in different sheets.
Rename the sheet as ‘Aniket’.
Insert a new sheet and name it as ‘Kunal’.
Insert marks secured by Kunal. ('90' in English, ‘85’ in Hindi, ‘86’ in Maths, ‘84’ in Science and
‘78’ in Social Studies).
Insert a sheet and name it as ‘ConsMarks’ which contains total marks obtained by each student
along with their names. Use Cell Referencing method to display Total Marks.
Save the spreadsheet as Report Card.
Linking Spreadsheet Data 181

