Application of WPS form to make class Teacher Allowance distribution table template

Source: Internet
Author: User

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

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.