Filter statistics in WPS table

Source: Internet
Author: User

Think back to the school that will, after the examination, all to help the teacher register results, and then make a statistic, the data is dazzling, error prone. The following small series for everyone to introduce the use of WPS form the screening function can easily complete the statistical work of student achievement.

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.

Drop down button

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

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

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 display all, follow the ' filter '-' Show All ' command in the ' Data ' menu.

Request B: List the scores of the 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 '.

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 ' Custom AutoFilter ' dialog box, select ' greater than or equal ', enter ' 60 ', select ' with ' relationship, select ' Less than ', enter ' 85 ', click OK.

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.

The above is the use of WPS Table screening function to complete the statistical work of student scores. In fact, the method is very simple, as long as your basic mathematical knowledge is no problem, you can count the number of men and women you want to know different grades. I hope the above content is helpful to you.

Related Article

E-Commerce Solutions

Leverage the same tools powering the Alibaba Ecosystem

Learn more >

Apsara Conference 2019

The Rise of Data Intelligence, September 25th - 27th, Hangzhou, China

Learn more >

Alibaba Cloud Free Trial

Learn and experience the power of Alibaba Cloud with a free trial worth $300-1200 USD

Learn more >

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: and provide relevant evidence. A staff member will contact you within 5 working days.