WPS helps teachers to easily check students ' scores in various subjects

At school, often at the end of the semester, the parents ran to the school to find a teacher to consult their children's final exam situation, teachers also in order to cope with the thick of the results of this, a page of the search, in fact, the use of WPS table can be quite easy to solve the relevant query problems, eliminating all the time to turn the book. Specifically as follows:

Effect Preview

① make the relevant data and enter the formula in cell H3: "=vlookup (h2,b4:e21,2,0)" VLOOKUP indicates that the first column of the table or array of values looks for the specified value and thus returns the value at the specified column in the current row of the table or array.

Figure 1

Cell H4, H5 the same input, the formula according to the corresponding situation to make corresponding changes.

In cell G, enter "name, language, mathematics" and other Related materials. In this way, all the students of the various subjects of the results of the corresponding.

② in the "Total Score" column (cell H6) input summation formula: "=sum (H3:H5)", to find the sum of each section.

Figure 2

③ in the "Average score" column (cell H7) Enter an average formula: "=average (H3:H5)" To find out the average points of each section.

Figure 3

For convenience, then set the cell format to "decimal" to retain two bits.

Figure 4

④ in the "Evaluation" column (cell H8) input judgment formula: "=if (h7>=60," Pass "," failed ")" to judge or fail (in general, 60 points as the standard)

Finally, the table is slightly beautified, you can.

In the future, as long as the "small white" place to enter the corresponding name can easily query the performance of a student.