WPS Table Tutorial: How to make automatic quiz and scoring multi-digit problem template

Since the provincial education department made a one or two-grade primary school does not allow the provision of written homework, many math teachers to the parents assigned a special assignment: every day to the children out of the 10 crossing computation, parents correcting and guide the child correction. I was always lazy. After receiving the assignment, I subcontracted the project to the WPS form (ET). and take the table multiplication multi-digit as an example, see how et how to complete this project!

First, randomly generated multi-digit problem.

As shown in Figure 1, enter in A2: =int (rand () *10) & "X" &int (rand () *10).

Explanation: RAND () represents a randomly generated decimal number between 0 and 1.

RAND () *10 represents a randomly generated 0 to 1 decimal number multiplied by 10.

The INT (RAND () *10) indicates that the number generated above is rounded to get 0~9 10 natural numbers.

The INT (rand () *10) & "X" &int (rand () *10) represents a formula that multiplies the natural numbers of two randomly generated 0~9. "&" is a connection symbol, "X" is a multiplication.

Picture 1

Second, the generation of this multi-digit problem.

Randomly generated multi-digit, click to change, so after copying it, paste it in the following formula column as a numeric format.

Third, set the answer area.

Iv. set the correct answer area and hide it.

In D2, enter =left (b2,1) *right (b2,1), which means that the first character on the left of the B2 grid is story multiplied by the first word on the right, and "*" is the multiplication symbol for the spreadsheet identity. See picture 2.

Select the D column and set the Hide.

Picture 2

V. Setting the score.

In E2, enter =if (c2= "", "", if (c2=d2,10,0)), said if the correct answer to give 10 points, the wrong answer to 0 points, did not answer without scoring. See picture 3.

The SUM function is used to find the total score in the E12 lattice.

Picture 3

Triple Recommendation: Click for free Download the latest version of WPS Office software "to see more computer tutorials

As for addition, subtraction, division, you can extrapolate, self-made template, you are welcome to make the template released for everyone to share.