Page 22 - Code & Click - 7

D. Answer the following questions.

1. What is Flash Fill feature? How does it work?
2. What do you mean by sorting data? Write the steps to sort data on multiple columns in a
worksheet.
3. What is the use of Filter feature in Excel? Write the steps to filter data on the basis of specific
values in a cell range.

4. What is conditional formatting? Write the steps to remove conditional formatting applied to
cells.
Logical Thinking
Mind Stretching
1. The teacher has alloted the usernames to the students of class VII to access the computers in
the lab. The username is in the form of ‘Firstname.RollNo.class7’. The given worksheet displays
the First name and Roll No of each student. Which feature of Excel you would use to fill the
respective usernames for the students quickly?

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?

Computational Skills
Lab Work

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.

20