Page 63 - TP_Modular_V2.1_Class7
P. 63

•   Data Bars: This option is selected when you want to add data bars to the cells
                               having numeric data. When you hover mouse over this option, it opens a sub-list

                               showing bars of different types and colours that can be added to the cells.
                           •   Color Scales: This option is selected
                               when you want to add colour schemes
                               to  all selected cells slowly varying
                               from  top  to  bottom  items. When

                               you  hover  mouse  over  this  option,
                               it opens a sub-list showing different
                               colour variations that can be added
                               to cells.
                                                                                   Using Conditional Formatting
                           •     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 is hovered over this option.

                 The selected conditional formatting is applied to the
                 selected cell range. You can also define your own rule
                 for highlighting cells by selecting New Rule option
                 from the Conditional Formatting drop-down list.
                 The conditional formatting features applied to a data
                 range can be cleared by selecting Clear Rules option
                 from the Conditional Formatting drop-down list.
                                                                                   Conditional Formatting applied
                    USING DATA VALIDATION

                 Data validation means to restrict the user to enter a specific range of values in a particular cell or
                 a range of cells. Perform the following steps to use data validation:
                 Step 1   Select the cell or a range of cells on which you want to apply data validation.
                 Step 2   Click on the Data Validation command from the Data Tools group of the Data tab. A
                         drop-down list appears.
                 Step 3   Select the Data Validation option. The Data Validation dialog box appears with the
                         Settings tab selected.

















                                         Data Validation                  Data Validation dialog box



                                                                                           Excel as Database      61
   58   59   60   61   62   63   64   65   66   67   68