Page 64 - TP_Modular_V2.1_Class7
P. 64

Step 4   Select the desired option from the Allow drop-down list. In this case, we have selected
                          Whole number option.

                  Step 5   Enter the minimum and maximum values in the Minimum and Maximum textboxes.  In
                          this case, we have typed 0 and 100 respectively.
                  Step 6  Select the Input Message tab.
                  Step 7   Type Data Validation in the Title textbox and Number
                          should be greater or equal to 0 and less than or equal
                          to 100 in the Input message text area.

                  Step 8    Select the Error Alert tab and type the error message
                          in the Error message textbox which you want to display
                          when user enters the incorrect value. In this case, we
                                                                                             Typing input message
                          have typed Invalid number.












                                                               Error message
                  Step 9   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.

                      USING SUBTOTAL COMMAND

                  The Subtotal command allows you to calculate
                  group-wise sum. It also calculates the grand total at the end.
                  Before using the Subtotal command, data must be sorted
                  in ascending or descending order. Perform the following
                  steps to use the Subtotal command:
                  Step 1   Select the data on which you want to apply Subtotal
                          command.                                                                Sorted data
                  Step 2   Click on the Subtotal command in the Outline group of the Data tab. The Subtotal
                          dialog box appears.

                  Step 3   Select the column according to which you
                          want to calculate subtotal from the At each
                          change in drop-down list. In this case, we
                          have selected T-Shirt Size column.

                  Step 4   Select the function which you want to use
                          from  the  Use function  drop-down  list.
                          In this case, we have selected the Count
                          function.                                       Subtotal dialog box      Calculated result



                   62       Modular (Ver. 2.1)-VII
   59   60   61   62   63   64   65   66   67   68   69