Page 27 - TP_Plus_v4_Class7
P. 27
Timeline
Sorting data means to organise the data in ascending or descending order.
Custom sorting is used to apply sorting on more than one column in selected range on different
criteria.
The filters can be easily applied and removed according to the user’s requirements.
Conditional formatting can be applied on the basis of different criteria.
Choose the correct option.
1. Under which tab is Sort & Filter command present?
a. Home b. Insert
c. Formula d. View
2. We use Sort A to Z option to sort .
a. Numbers b. Text
c. Symbols d. All of these
3. Near which option do small arrows appear when we apply filter feature?
a. Row headers b. Column headers
c. Sheet tabs d. None of these
4. Which of the following is not a category used in conditional formatting?
a. Data Bars b. A to Z
c. Top/Bottom Rules d. Icon Sets
5. Which option is used to remove conditional formatting?
a. New Rule b. Clear Rules
c. Remove Rules d. Delete Rules
Tick () the correct statements and cross () the wrong ones.
1. Excel can arrange data in ascending order only.
2. You cannot sort more than one column at a time in a selected range of cells.
3. The Add Level button is available under the Insert tab.
4. Excel also allows you to use custom filter.
5. Conditional Formatting is only used with numeric data.
#Advanced Features of Excel 25

