Mr. Sachin wants to see the marks of students of Class XIIA. To do this, he can use another feature of spread sheet – 'filters'. What are the steps…

Following are the steps to apply filters to a table. I. Click on ‘Auto filter’ II. Click on the filter for class column III. Drop down will show the list of all values IV. By default all values are checked V. If you want to check data of XII A then uncheck class XII B VI. Click on ‘OK’ VII. Data of XII A will be displayed