Page 27 - Computer - 7
P. 27
2. The teacher asked Srishti to enter unit test marks obtained by students of her class in an Excel
worksheet. She also asked her to highlight the students’ names who scored less than 40 marks
with red colour. Which feature of Excel should Srishti use to accomplish the task?
Lab Work Computational Skills
A. Create an Excel worksheet for the students of a school who are selected in various sports for the Inter-
school Sports Competition.
(a) Create an Excel worksheet for the students of a school who are selected in various sports for the
Inter-school Sports Competition.
(b) Filter the data to display the names of students participating in Badminton.
B. The worksheet given below gives the sale of cakes and chocolates in a bakery shop.
Format the worksheet as per the given instructions:
(a) Fill the cells where items sold are more than 20 with green colour.
(b) Fill the cells where items sold are less than 10 with red colour.
DISCUSS
DISCUSS Communication Skills
How do you think the advanced features in Excel help while working with large volume of data on a worksheet?
Discuss with your classmates.
TEACHER’S DESK
TEACHER’S DESK
Explain to the students the different ways in which Sort, Filter, and Conditional Formatting features in Excel can
be used.
25
