Page 61 - TP_Modular_V2.1_Class7
P. 61
Step 5 Click the Sort by box to open list of column headers. Select a column head, for example
‘Marks Obtained’.
Step 6 Click on the Sort On box to select Values option.
Step 7 Click on the Order box to select A to Z option in case of text data and Smallest to
Largest option in case of values.
Step 8 Click on the Add Level button on the top of the dialog box. This will add one more row
to define new criteria.
Step 9 Repeat steps 5 to 7 to sort Marks in previous term column in descending order.
Step 10 Click on the OK button. The data will be sorted according to the criteria defined.
Sort dialog box Sorted data
FILTERING DATA
You must have studied about filtration process which is used to separate unwanted material
from a mixture. Excel also provides you to filter unwanted data from a set of data.
To apply filters, follow the given steps:
Step 1 Select the range of columns to be filtered.
Step 2 Click on the Sort & Filter command from Editing
group under Home tab to open a drop-down list.
Step 3 Select the Filter option from the drop-down list.
You will notice that small arrows appear in front
Unfiltered data
of all the column headers.
Step 4 Click on the arrow in front of the header Marks
Obtained to open a drop-down list. You will notice
that all the entries in the column are present in the
list with small checkboxes in the beginning. Click
some of the checkboxes to uncheck them. Click on
the OK button. Filtered data
You will notice that the rows of unchecked data are removed from the list. You need not worry
as the data is not lost. Notice the row headings. Some of the row headings are missing. The
unchecked rows have just been hidden from the display. To get the data back, open the filter list
again and check the unchecked entries.
Suppose, you want to know the names of the students who have scored more than 80 marks.
Excel as Database 59

