Page 50 - ThinkGPT_V2.1_C7_Flipbook
P. 50

The filter can also be applied through Sort & Filter group under the Data
                                                 tab by selecting Filter command      .



                  Remove 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.
                                                                                       Information Literacy
                         byte Quest                                                    Critical Thinking



                       Tick ( ) the correct statements.
                       1.   By default, Form command is not visible on the ribbon.

                       2.  Delete button is used to delete the record from the worksheet.

                       3.  The filters once applied cannot be easily removed.
                       4.  Excel allows you to filter unwanted data from a set of data.





                  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:


                                        2  Click on Conditional Formatting command
                                        under Styles group in Home tab.


                                                                                        3  Place your mouse over
                                                                                        Highlight  Cell  Rules
                                                                                        option  and  select  the
                                                                                        Greater Than option.















                           1  Select the data to which formatting is to be applied.



                       48    Premium Edition-VII
   45   46   47   48   49   50   51   52   53   54   55