WPS table Automatic Screening statistics student scores

As a teacher of the school, every test will come to a complex, cumbersome student performance statistics work, WPS table screening function can help me to complete the student score statistics easily.

Fig. 1 Student score Table

Let's take a look at how the automatic filtering feature in the WPS table can help me quickly finish my score.

The automatic filtering operation of the WPS table is very simple, select any cell in the table, and perform the filter-AutoFilter command in the Data menu. At this point, a Drop-down button appears on the right side of each column heading.

Request A: List the scores of students with a score of 98 points in English

　　Operation steps: Click on the column title ' English ' Right Drop-down button, select the ' 98 ' in the Pull-down menu. As shown in Figure 2:

Fig. 2 Scores of students with 98 points in English

Note that at this time the English score is not 98 points of the students are hidden, not be deleted. The result of AutoFilter is to show only the rows that meet the specified criteria, and hide the rows that do not meet the specified criteria.

If you need to show all, follow the ' filter ' in ' Data ' menu-' Show all ' command

Request B: List the scores of students with political scores above 60 points

　　steps: Click on the column heading ' Politics ' right drop-down button, select ' Customize ' in Pull-down menu, popup ' Customize AutoFilter ' dialog box, select ' Greater than ', enter ' 60 ' and click ' OK '. As shown in Figure 3:

Figure 3 Customizing Automatic filtering

Requirement C: List of boys with a language score greater than 60 points and less than 85 score

　　Operation steps: Click on the column heading ' language ' to the right of the Drop-down button, select ' Customize ' in Drop-down menu, popup ' Customize AutoFilter ' dialog box, select ' greater than or equal ', enter ' 60 ', select ' Less ', enter ' 85 ', Figure 4: Click OK.

Figure 4 Customizing Automatic filtering

Click on the column heading ' Sex ' to the right of the dropdown button, select ' Male ', at this time, just click a few mouse clicks, meet the requirements of C results have been screened out. As shown in Figure 5:

Fig. 5 Results of boys with a language score greater than 60 points and less than 85 points, more WPS tutorials