Page 55 - KEC Khaitan C6 Flipbook
P. 55

CONDITIONAL FORMATTING


                 To apply conditional formatting to a series of data, follow the given steps:


                                                            1  Select the data and click on the
                                                           Conditional Formatting command.





                                                                                               2  Select the
                                                                                               desired option.




                                                                                               3  Choose
                                                                                               desired fill effect.












                         uiz   Bee        Write the use of custom sorting.
                                          _________________________________________________________________








                        Hashtag

                      #SUM(): This function is used to calculate the total of a given set of values
                      #IF(): This function is used to check a condition to be evaluated as True or False





                      REVISIT



                   ▶   The SUM() function calculates the total of a given set of values.
                   ▶   The IF() function checks a condition to be evaluated as True or False, and based on the result, suitable
                     actions are performed.
                   ▶   The physical arrangement of data in ascending or descending order is called sorting.
                   ▶   The feature of viewing rows of data suiting a specified selection criterion is called filtering data.









                                                                                         Advanced Features of Excel  53
   50   51   52   53   54   55   56   57   58   59   60