Page 33 - TP_Pluse_V2.2_Class_7
P. 33

Color Scales: This option is selected when you want to add colour
                   schemes to all selected cells slowly varying from top to bottom                   Factopedia
                   items. When you hover the mouse pointer over this option, it
                   opens a sub-list showing different colour variations that can be
                   added to cells.

                     Icon Sets: This option is selected when you want to add icon sets
                   to show which cells are acceptable, which are moderate and which
                   need attention. The different types of icon sets that can be added
                   are  shown in the  sub-list that  opens  when the  mouse  pointer  is       Freeze Panes feature
                   hovered over this option.                                                     allows you to lock

                 Step 3:   Select  the  desired conditional  formatting.  In this  case,  we   your column/row so
                         have selected the Orange Data Bar option under the Data               that, when you scroll

                         Bars category. The selected conditional formatting is applied          down or up to view
                         to the selected cell range.                                           the rest of your sheet,
                                                                                                the locked column/
                                                                                                row remain on the
                                                                                                      screen.














                                                                                                    The earliest
                                       Using conditional formatting
                                                                                                 date allowed for
                 You can also define your own rule for highlighting cells by selecting        calculations in Excel is
                 New Rule option  from the  Conditional  Formatting drop-down list.              January 1, 1900.
                 The conditional formatting features  applied  to  a data  range can
                 be  cleared  by  selecting  Clear Rules option  from the  Conditional
                 Formatting drop-down list.


                            Let’s BaCk-uP


                        Sorting data means to organise the data in ascending or
                      descending order.
                                                                                              If you need 1 second to
                        Custom sorting is used to apply sorting on more than one               fill out 1 cell, it would
                      column in selected range on different criteria.                          take you 545 years to
                        The filters can be easily applied and removed according to the          complete the whole
                      user’s requirements.
                                                                                                    worksheet.
                        Conditional formatting can be applied on the basis of different
                      criteria.


                                                                                        Advanced Features of Excel  31
   28   29   30   31   32   33   34   35   36   37   38