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

