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

