Current location - Training Enrollment Network - Mathematics courses - The teacher assigned homework and gave the children 20 math problems with the sum of three numbers of 10 every day. I think this can be automatically generated by excel. How?
The teacher assigned homework and gave the children 20 math problems with the sum of three numbers of 10 every day. I think this can be automatically generated by excel. How?
A2=ROUNDUP(RAND()* 10，0)

B2= 10-A2-C2

C2=ROUNDUP(RAND()* 10，0)

Copy down the three formulas.

Press F9 to randomly generate three addends.

Related articles
  • Math problem 333=6
  • Seek the summary of the knowledge points in the first and fourth chapters of the first grade mathematics of Beijing Normal University! ! ! ! ! ! ! ! ! ! !
  • Hunan Education Edition Mathematics Ninth Grade
  • What are the puzzles in mathematics? Write questions and answers.
  • Mathematics in the second volume of the seventh grade
  • How to treat the position and function of "Mathematics Curriculum Standard for Ordinary Senior High Schools"
  • What happens if you calculate the last digit of pi?
  • World ranking of mathematics department of University of Waterloo
  • Sichuan University Biomedical Engineering Postgraduate Entrance Examination Experience Sharing?
  • What are the majors of the Graduate School of China University of Science and Technology?

    • copyright 2024 Training Enrollment Network All rights reserved