Page 52 - Digicode_AI_class_7
P. 52

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:

                      2  Click on the    3  Click on the Data
                     Data tab.          Validation command.


                                                                                       4  Select the Whole
                                                                                       number option from
                                                                                       the Allow drop-
                                                                                       down list.


                                                                                       5  Enter 0 and 100
                                                                                       values in the Minimum
                                                                                       and Maximum
                                                                                       textboxes respectively.

                 1   Select the  cell  or  a  range  of  cells  on
                which you want to apply data validation.



                                                                           9  Select the Error Alert tab and
                                           6  Select the Input            type the error message in the Error
                                           Message tab.                   message textbox.





                       7  Type Data
                      Validation in the
                      Title textbox.









                  8  Type Input message in the Input Message text area.       10  Click on the OK button.


            Now, if you enter the number which is not in specified range, you will get an error message as shown:


















                50     DigiCode AI-VII
   47   48   49   50   51   52   53   54   55   56   57