Wps table 2016 cells have spaces how to calculate the average?

Do you know how to calculate the average value in the 2016 cell of the wps table? I believe many friends don't know it! So the following small series for everyone is the wps table 2016 cells have a space to calculate the average method, friends who want to know come see!
wps table 2016 cells have spaces to calculate the average:
1, first open the wps program, create a new form.

2. After creating a new form, open a last year's transcript and put it in sheet2. The figure is an example, free to write as a transcript

3, select the intrinsic content in sheet2 to copy and paste to sheet1, such as subject name, student name


4, remove or Add a student name that is different from previous years. For example, this year Qian Moumou failed to take the test due to special circumstances. Select the left side of Qian Moumou, click the right button to hide

5, and then follow the scores to score each person's grades. Input, here can only be manually entered, but some numbers are also very fast

6, then select a student's grades, as shown in the figure, then pull to the total score column, click on the upper column If you sum, you can get the total score. Then select all the grades again (except the total score), then click on the small triangle below the summation, select the average value inside, and then automatically generate the average of the students in the following average column


7, this only finds the data of a classmate, then select the total score value as shown in the figure, place the mouse in the lower right corner, and drag down when the mouse turns into a black cross. The dotted box is then pulled to all the students and released, and the data is automatically generated. The average is the same way.