WPS table How to make the score sheet

WPS forms the method of making the score sheet:

First set up a table frame, input form name, each name, and then fill in the content

Center text when you move to the square appears white cross right click, click like Symbol, and then select Horizontal Center, the success of the center,

Enter the class when one input center is too slow, first input a grid, the mouse to the black box to the lower right corner of the black cross, while holding down CTRL pull, enter the test number when the input start test number, such as: 1 direct pull down,

I just typed in some people and scores, and then I asked for the total score. Total score need to use the sum, before the need to enter complex functions, now just click Start, click on the right to sum, select the sum, will appear in the following image of the function, (note: Before the sum of the mouse click on the box appears in the black frame position will be the result of where), Use the blue box to select the sum of the items, and then enter, sum the result came out, need to require all of the following, with step 3, directly down, "No" CTRL results as shown

The following is the average, click the result position square, click Start, sum the triangle below, choose the average, box select a list of the number, carriage return, other subjects total sum, horizontal pull black box, as shown, the final score table completed

Sometimes you also need to rank according to the score, box selected items, click Start, select Sort, custom sort, select sort according to a column of keywords, I selected the total score that column, descending sort, (descending is from big to small), click OK