2. Then click the "Enter" key, and the A2 cell will automatically generate a random number. For example, if the number is 7, pressing the "F9" key can also generate other numbers from 0 to 9 at will.
3. Enter the+(-,x) symbol in cell B2, then enter the formula in cell C2 by the method of step 1, and finally enter the = symbol in cell D2. This oral arithmetic problem is finished.
4. The automatic generation method of "addition, subtraction, multiplication and division" is mentioned above, so how to do the division problem? If you don't consider whether there is a remainder, that is, whether it is divisible or has a remainder, use the above method = rand between (10/0,99) ""&; RANDBETWEEN( 1, 9)"= "will do.
5. If you want to divide the remainder exactly, you need to randomly generate an integer as the divisor, and then multiply it by another integer to get the dividend. Such as step 1 formula operation,? Generate a divisor between 1 and 9 in A2.
6. Then enter the formula =A2 in the D2 cell, the formula =A2*D2 in the B2 cell, the ÷ symbol in the C2 cell and the = symbol in the E2 cell. The formulas are all ready, but they need to be hidden. This oral arithmetic problem is finished.