At the beginning of each month, the administration and Education Department should combine the examination results of each class to produce the statistical tables of the class teacher allowance (Author Note: The monthly allowance of the teacher in charge of our school is composed of three parts: the basic allowance is 60 yuan, the number of allowances per student is 1 yuan, the reward allowance is divided into two, the Advanced class is 100 yuan, and the ordinary classes are 80 yuan. ), in order to improve work efficiency, the author used a WPS form to create a template (Figure 1), just double-click the template to run the WPS table, in the new table to modify some of the data, the relevant results will be automatically generated, very convenient and quick.
Figure 1
The template production process is as follows:
First, create a new workbook and enter the underlying information.
Run the WPS table, create a new blank workbook, enter the basic information on the worksheet, and adjust the column widths according to the content (Figure 2), please refer to the examples in detail.
Figure 2
Second, the writing function completes the correlation computation, and the reasonable establishment cell format.
1, the total amount is three of the sum of allowances, selected F4 cell, click the Common toolbar in the "Auto sum" button (such as Figure 3), the WPS table intelligently determine the sum range c4:e4 is correct (Figure 4), we just hit enter to confirm it.
Figure 3
Figure 4
2, select F4 cell again, with the mouse to double-click the lower right corner of the cell control point (small black box), you can complete the rest of the formula fast input (Figure 5).
Figure 5