Create a new worksheet (this paper takes WPS form as an example, which is basically the same as excel). Enter the minimum value in cell A 1 and the maximum value in cell C 1. F 1 Enter "Maximum Result" in the cell. (By changing these parameters, you can generate math problems in different ranges, such as 10 to 30, and the result is not more than 50. ) and fill in 10, 30 and 50 in cells B 1, D 1 and F 1 respectively. Enter the number 1 in cell A2, 2 in cell B2, 3 in cell c2, 1 in cell d2, 2 in cell e2, intermediate result in cell F2, final result in cell G2, serial number in cell H2 and number in cell I2. Addition and subtraction can randomly generate 0, 1 through randbetween(0, 1), and cooperate with IF function to generate "+"and "-". =IF(randbetween(0, 1), "+","-"). But considering that the intermediate result and the final result are also related to the addition and subtraction here (the intermediate result and the final result also need to meet the description in step 3). So D3 cell input "= if (and (G3 >; 0,G30,G3
Microsoft Excel is a spreadsheet software written by Microsoft for computers using windows operating system. Intuitive interface, excellent calculation function and chart tools, coupled with successful marketing, make Excel the most popular personal computer data processing software. 1993, after the release of version 5.0 of Microsoft Office component, Excel began to become the overlord of spreadsheet software on the applicable operating platform.