Page 55 - ModularV1.1 _c7_flipbook
P. 55
Step 4 Check My data has headers checkbox if the selected columns have a heading at the top.
Step 5 Click the Sort by box to open the list of column headers. Select a column head, for
example ‘Marks Obtained’.
Step 6 Click the Sort On box to select Values option.
Step 7 Click the Order box to select the A to Z option in case of text data and Smallest to
Largest option in case of numerical data.
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 the filtration process that is used to separate unwanted materials
from a mixture. Excel also provides you to filter unwanted data from a set of data.
To apply filters, follow these steps:
Step 1 Select the range of columns to be filtered.
Step 2 Click the Sort & Filter command from the Editing
group under the Home tab to open a drop-down list.
Step 3 Click Filter from the drop-down list. You will notice
that small arrows appear in front of all the column
headers.
Unfiltered data
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.
Using Filter command Filtered data
Excel as Database 53

