WPS Table Tutorial: Proofreading of data when working together

Before the annual final exam, several towns have to work together to read, but to compare the results. Of course, it is not advocated now. After the test paper has been changed, two different villages and towns should be registered separately for the results of another township, and then the results will be proofread to prevent any mistakes. Found that there are differences, according to the study number to find the original test paper to compare, to obtain the final results. So how do you compare the differences between the two registration forms?

One, two copies of the results to one place.

Since everyone is using the same login form, just copy and paste the scores from one of the tables into the other, so that the student scores in the two tables correspond.

Second, the calculation of the difference of two results, such as the two performance difference is zero, indicating that the two units registered results are consistent, the results are registered correct. If the score difference is not 0, then the two units register the results are inconsistent, to find a test paper re-registration.

Third, to identify differences in the results.

As a result of the rural joint examination, students are more, so can not be manually investigation by line. Therefore, we can use the automatic screening to detect differences in students ' academic numbers.

Click "Data-Filter-AutoFilter". Select Custom in the pop-up Drop-down list box, and then in the Custom AutoFilter dialog box that pops up, select the criteria "not equal to", enter the parameter "0", and click OK to get the student number for which all the score statistics are divided.