Page 35 - Plus_V2.2_C7_Flipbook
P. 35
a. What is the difference between sorting data and filtering data?
b. Write the names of the criteria on the basis of which conditional formatting can be applied.
c. Write the steps to apply Custom Sort feature.
d. Write the steps to apply conditional formatting.
fun Zone
Let's soLve Experiential Learning
1. Application based question.
John is preparing a list of students with their marks obtained in exams. He wants to arrange
the data in ascending order according to the students names. Suggest him a feature of Excel
which helps him in doing his work quickly.
2. Guess who am I? Critical Thinking
a. I am a group of the Home tab that contains the Sort & Filter command. ____________
b. I am a feature in Excel to separate unwanted data from a range of data. ____________
c. I am a feature in Excel to arrange data in ascending or descending order. ____________
d. I am a type of formatting that can be applied on the basis of a criteria. ____________
e. I am the order in which the data is arranged from smallest to largest. ____________
Let's exPLore
Find out the various ways in which people organise data to make their everyday work easier.
You can start this by asking a shopkeeper.
teCh PraCtiCe Interdisciplinary
1. Make a list of your 10 friends in Excel. Make columns for the distance of their home
from school, distance of post office from their home, etc. Use sorting to arrange data in
an order. Highlight the cells which have distance less than 2.5 km in any cell.
2. Make a list of 15 teachers and subjects taught by them. Apply Filters on the subject’s
field. Take printouts of various filter options of subjects and their result.
For The Teacher
Demonstrate to the students the concepts discussed in the chapter.
Make the students understand differences between filtering and sorting features.
Advanced Features of Excel 33

