Page 58 - ModularV1.1 _c7_flipbook
P. 58

Step 6  Select the Input Message tab.

                  Step 7   Type Data Validation in the Title textbox and Number
                          should be greater or equal to 1 and less than or equal
                          to 31 in the Input Message text area.
                  Step 8   Select the Error Alert tab and type the error message in
                          the Error message textbox that you want to display when
                          the user enters the incorrect value. In this case, we have
                          typed Invalid number.
                                                                                             Typing input message
                                               Step 9   Click on the OK button. Now, if you enter the number that
                                                        is not in specified range, you will get an error message as
                                                        shown.


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








                                                       Subtotal command on ribbon
                  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.
                  Step 5   Select the column in which you want
                          to add subtotal from the Add subtotal

                          to drop-down list.
                  Step 6   Click on the OK button. The subtotal
                          and grand total will appear.





                                                                  Subtotal dialog box           Calculated result

                  56      Modular (Ver. 1.1)-VII
   53   54   55   56   57   58   59   60   61   62   63