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
   57   58   59   60   61   62   63   64   65   66   67