Page 35 - TP_Pluse_V2.2_Class_7
P. 35
4. Long answer type questions.
a. What is the difference between sorting data and filtering data?
______________________________________________________________________________
______________________________________________________________________________
______________________________________________________________________________
b. Write the steps to apply conditional formatting.
______________________________________________________________________________
______________________________________________________________________________
______________________________________________________________________________
c. Write the steps to apply Custom Sort feature.
______________________________________________________________________________
______________________________________________________________________________
______________________________________________________________________________
5. Competency-based/Application-based questions.
a. 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.
b. You are tracking student participation scores from 0 to 100. How would you use Conditional
Formatting to highlight scores below 50 in red and above 80 in green? What are the benefits of
this approach?
teCh Zone
Let's soLve 21 st
Century #Critical Thinking
Guess who am I? Skills
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. ____________
21 st
Let's exPLore Century #Leadership & Responsibility
Skills
Find out the various ways in which people organise data to make their everyday work easier.
You can start this by asking a shopkeeper.
Advanced Features of Excel 33

