Page 75 - TechPluse_C6_Flipbook
P. 75
Step 2 Click on the Data menu.
Step 3 Select the AutoFilter option. You will notice that small
arrows ( ) appear in front 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 check boxes
in the beginning.
Using AutoFilter option
Step 5 Click some of the check boxes to uncheck them.
Step 6 Click on the OK button.
Filtered data
Using filter options
You will notice that the rows of unchecked data are removed from the list. You need not to 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. Follow these steps to get the required information:
Step 1 Apply filters to the data.
Step 2 Click on the Marks Obtained
column header to open the filter
drop-down list.
Step 3 Place your mouse over Standard
Filter option to open Standard
Filter dialog box.
Step 4 Click on the Field Name
drop-down list and select the
Marks Obtained. Using Standard Filter
Formulas, Functions and Charts in Calc 73

