Page 24 - TP_V5.1_C7_fb
P. 24
2. Fill in the blanks using the words from the help box.
Color Scales, Sorting, Add Level, Filter
a. The physical arrangement of data in ascending or descending order is called _____________.
b. _____________ option shows the data you wish to see while hiding the rest temporarily.
c. _____________ option is selected when you want to add colour schemes to all selected cells slowly
varying from top to bottom items.
d. _____________ button is used to add another column for sorting.
3. Think and answer.
a. How can we remove the filters from the worksheet in Excel?
______________________________________________________________________________________
b. How do you apply custom sorting to the data?
______________________________________________________________________________________
______________________________________________________________________________________
______________________________________________________________________________________
c. Write the steps to apply conditional formatting.
______________________________________________________________________________________
______________________________________________________________________________________
d. How do you filter the data in Excel?
______________________________________________________________________________________
______________________________________________________________________________________
______________________________________________________________________________________
4. Differentiate between the following:
Sorting data Filtering data
__________________________________ __________________________________
__________________________________ __________________________________
5. Competency-based/Application-based questions. Experiential Learning
a. Divya was making a list of all the students of her class. She wishes to sort them alphabetically. Which
type of sorting can she use for this?
______________________________________________________________________________________
b. Chirag wants to highlight the names of those people on a list who have the same age as him. Which
feature can he use for this?
______________________________________________________________________________________
c. Subhash wants to highlight the names of students who have scored marks between 50 and 80 in
any subject. Which feature of MS Excel can he use for this?
______________________________________________________________________________________
22 Premium Edition-VII

