Page 31 - C_GPT _V4 _class_7
P. 31
4. If the existing Conditional Formatting rules do not meet your requirements, which option will you use
to create your own rules?
Scratch Your Brain. 21 st Century #Critical Thinking
Skills
#Initiative
1. Analyse the following data and answer the questions given below:
Roll No. Name Age Gender Grade Math Score Science Score English Score
101 Rahul 17 Male 11 85 78 82
102 Priya 16 Female 10 92 85 88
103 Rohan 18 Male 12 78 80 75
104 Nisha 17 Female 11 88 90 85
105 Sameer 16 Male 10 90 85 80
a. Which feature is used to display the records of female students only?
b. Which feature is used to arrange the data in the descending order of English Score?
c. Which feature is used to highlight the cells in the Grade column where grade is 10?
2. Competency-based/Application-based questions:
a. Anika is responsible for organising and prioritising tasks for her team using Excel.
She wants to sort the tasks based on the priority, where tasks with the same priority
are sorted alphabetically by their names. What can she do to achieve this?
b. Ravi has the following data in an Excel worksheet:
Name Marks
Divya 97
Mihir 76
Tanya 88
Rishi 89
Shivam 78
He wants to sort the data according to the names of students. Help him by writing the steps to do so.
Advanced Features of Excel 29

