Page 23 - TP_Plus_v4_Class7
P. 23
To use Custom Sorting, follow these steps:
2
Click on the Sort & Filter command.
Select the range
1 of columns to
be sorted.
3 Click on the Custom
Sort option.
Check My data has headers
8 Click on the Add Level checkbox, if the selected columns 4
button.
have a heading at the top.
Click on the Order box
and select the A to Z 7
or Z to A option.
Click on the Sort by
5 box and select the
column header.
Click on the Sort On box and 6
select Cell Values option.
Hintbot
To sort data: click
Data Sort
9 Similarly, set the sorting criteria for the
second column and click on the OK button.
Experiential Learning
#Sorting
Do a poll/survey of students of your class on festivals of India. Visit https://utsav.gov.in/ and find the
relevant information about each festival. Create an Excel sheet of the festival each student likes
and sort the data according to the name of the student alphabetically.
#Activity
#Advanced Features of Excel 21

