Page 25 - Plus V4 with Adobe class 7
P. 25
2 Click on the Marks Obtained in
Second Term header.
1
Apply filters to the data.
Select the Greater
Place your mouse over Than option. 4
3 the Number Filters
option.
5 Enter 80 in the
criteria box. Click on the 6
OK button.
Notice that only the details of the students who have obtained marks greater than 80 are displayed and
the remaining rows remain hidden.
Removing Filters
The filters once applied can be easily removed. Click anywhere in the worksheet and repeat steps to
apply filters. You will notice that the filter arrows in front of column headers disappear and the hidden
rows also reappear.
Double Tap Century #Critical thinking
21 st
Skills
Tick ( ) the correct statements.
1. Sorting of data means to organise the data in ascending or descending order.
2. Excel allows you to sort only one column.
3. The filters once applied cannot be easily removed.
4. Excel allows you to filter unwanted data from a set of data.
Art Integration Learning
#Sports
Make a list of one-day matches that have been held in the last two years. Consider any of the five countries
that have participated, including India. Make separate columns for the country name, runs, win, and loss.
Calculate the total number of matches and total number of runs. Find how many matches India won & how
many lost.
#Lab Activity
#Advanced Features of Excel 23

