Page 25 - Trackpad_V4.0_c7_Flpbook
P. 25
Check My data has headers
4 checkbox, if the selected columns
have a heading at the top.
8 Click on the Add
Level button. Click on the
Order box and
select the A to Z 7
Click on the or Z to A option.
Sort by box
5 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 Lab Activity
Do a poll/survey of the 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 listing the festivals that each student enjoys, then
sort the data alphabetically based on the student's names.
FILTERING DATA
You must have studied about the filtration process, which is
used to separate unwanted material from a mixture. Excel The moon highlights different aspects
also allows you to filter unwanted data from a set of data. at different times, much like filtering
focuses on specific data subsets.
Advanced Features of Excel 23

