Page 23 - TP_V5.1_C7_fb
P. 23
uiz Bee Write the use of custom sorting.
_________________________________________________________________
Hashtag
#Sorting: A method of arranging data in ascending or descending order.
#Filtering: This allows us to see the important data and hide the rest data temporarily from the
set of data.
REVISIT
▶ The physical arrangement of data in ascending or descending order is called sorting.
▶ Custom sorting is used to apply sorting on more than one column in selected range on different criteria.
▶ The feature of viewing rows of data suiting a specified selection criterion is called filtering data.
▶ Custom sorting is used to apply sorting on more than one column in selected range on different criteria.
1. Tick ( ) the correct option.
a. Which of the following options is used to sort the data in descending order?
(i) Sort Z to A (ii) Sort A to Z
(iii) Filter (iv) None of these
b. Which of the following features is used to view rows of data suiting a specified selection
criterion?
(i) Sorting (ii) Data Bars
(iii) Filter (iv) Both (i) & (ii)
c. Which of the following options is suitable when you want to highlight all the cells satisfying
a given condition?
(i) Data Bars (ii) Highlight Cells Rules
(iii) Color Scales (iv) None of these
d. Which of the following is not a category used in conditional formatting?
(i) Data Bars (ii) New Cell Style
(iii) Top/Bottom Rules (iv) Icon Sets
Advanced Features of Excel 21

