Page 62 - TP_Modular_V2.1_Class7
P. 62
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 Number Filters option to
open a sub-menu. Select the Greater Than option
to open the Custom AutoFilter dialog box.
Using Filter options
Step 4 Enter 80 in the criteria box and click on the OK
button.
Notice that only the details of the students who have obtained marks greater than 80 are
displayed and the remaining rows get hidden.
Remove Filters Clickipedia
The filters once applied can be easily removed. Click
anywhere in the worksheet and repeat steps to apply The filter can also be applied through
filters. You will notice that the filter arrows in front of Sort & Filter group under the Data tab
column headers disappear and the hidden rows also by selecting Filter command .
reappear.
CONDITIONAL FORMATTING
Suppose you do not want to hide any rows but still want to highlight all the cells that satisfy
a condition, for example greater than 80. This type of formatting is known as Conditional
Formatting in Excel. To apply conditional formatting to a series of data, follow the given steps:
Step 1 Select the data to which formatting is to be applied.
Step 2 Click on the Conditional Formatting command from Styles group under Home tab
to open a drop-down list. This list shows various criteria like:
• Highlight Cells Rules: This option is selected when you want to highlight all cells
satisfying a given condition. When you hover mouse over this option, it opens a
sub-list showing criteria like Greater Than, Less Than, Equal To, Between, etc.
• Top/Bottom Rules: This option is selected when you want to highlight some top
or bottom number of items in a data series. When you hover mouse over this
option, it opens a sub-list showing criteria like Top 10 Items, Top 10%, Bottom 10
Items, Bottom 10%, etc.
60 Modular (Ver. 2.1)-VII

