Page 41 - Computer Genius Class 07
P. 41

Notes

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



                 Remove Filters


                 The filters once applied can  e easily remo ed.  lic  any here in the  or sheet and repeat steps
                 to apply filters.  ou  ill notice that the filter arro s in  ront o  column headers disappear and the
                 hidden rows also reappear.
                                                                                      Information Literacy
                       Quest                                                          Critical Thinking



                      State whether these statements are true or false.
                      1.    y de ault  Form command is not  isi le on the ri  on.

                      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   or e ample greater than   . This type o   ormatting is  no n as Conditional Formatting
                 in   cel. To apply conditional  ormatting to a series o  data   ollo  the gi en steps


                                            2  Click on Conditional
                                            Formatting command.


                                                                                        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.



                                                                             Advanced Features of Excel 2016  39
   36   37   38   39   40   41   42   43   44   45   46