Page 397 - Trackpad 402_Class-X_Final
P. 397

13.  Consider the following marksheet and use the goal seek feature to find the marks in place of question mark (?).

















            14.  Start Calc and watch carefully all the components of Calc spreadsheet. Ask your computer teacher about the uses
                of different components of Calc worksheet.
            15.  Using Calc prepare a list of prizes won by different students in different events on the Annual Sports Day. Take a
                printout and paste it on the noticeboard of your school.














            16.  Create the following marksheet for ten students. Now, follow these instructions:
                •  Insert a row above 12  row.
                                     th
                •  Insert a column to the right of 4  column.
                                              th
                •  Using AutoFill features, fill the roll numbers 1 to 11 for the students.

















            17.  Add the following records in the Calc worksheet and apply the cell styles as per the following rules:
                •   The cells containing marks greater than or equal to 80 should be highlighted with Good cell style.
                •   The cells containing marks greater than or equal to 70 and less than 80 should be highlighted with Neutral cell style.
                •   The cells containing marks less than 70 should be highlighted with Bad cell style.

                                                              Subjects
                      Student Name        Hindi      English       Maths         Science     Computer Science

                    Amit                   67           77           90            85                 98
                    Divya                  87           65           80            98                 73
                    Chirag                 78           90           67            85                 92

                    Anshika                96           84           99            75                 62


                                                                                                 Practical Work  397
   392   393   394   395   396   397   398   399   400   401   402