Page 56 - ModularV1.1 _c7_flipbook
P. 56

You will notice that the rows of unchecked data are removed from the list. You need not 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  the  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
                  the column headers disappear and the hidden rows             by selecting the  Filter command     .
                  also 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 these steps:
                  Step 1  Select the data to which formatting is to be applied.

                  Step 2  Click on the Conditional Formatting command from the Styles group under the Home
                          tab to open a drop-down list. This list shows various criteria such as:

                               Highlight Cells Rules – This option is selected when you want to highlight all cells
                             satisfying a given condition. When you hover the 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 the mouse over this option,

                             it opens a sub-list showing criteria like Top 10 Items, Top 10%, Bottom 10 Items,
                             Bottom 10%, etc.
                              Data Bars – This option is selected when you want to add data bars to the cells having

                             numeric data. When you hover the mouse over this option, it opens a sub-list showing
                             bars of different types and colours that can be added to the cells.

                  54      Modular (Ver. 1.1)-VII
   51   52   53   54   55   56   57   58   59   60   61