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
   178   179   180   181   182   183   184   185   186   187   188