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

