Nowadays, the pace of people's life is getting faster and faster. In this fast-paced life, many applications also need innovation. Only in this way can we adapt to this fast-paced life. For example, in daily office, many civil servants will use office tools such as word.

Word is an office tool based on text editing, but if you encounter form editing, you need to choose Excel as the office tool. This office tool mainly focuses on table editing. But in addition to this table editing function, Excel can also perform data operations, such as sum, difference, average and so on. So the function of this office tool is very powerful. So, how to use it?

First, let's start with a set of simple multiplication problems.

Enter the following formula in the upper left cell, namely cell A 1:

=RANDBETWEEN( 1，9)amp； "?" & ampRANDBETWEEN( 1, 9) and amp"= "

Set the font number 16, copy a * * * every other column in the first line, and then drop down 20 lines with a height of 34.5.

A set of 100 questions is ready, preview the printing effect!

If each question to be printed is different, please press F9 to refresh before printing.

Next, let's see how to solve the division problem. If you don't consider whether there is a remainder, that is, whether it is divisible or has a remainder, this problem can be solved by referring to the fourth step. The formula for dividing two digits by one digit is as follows:

=RANDBETWEEN( 10，99)amp； "& Peter;" & ampRANDBETWEEN( 1, 9) and amp"= "

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. The steps are as follows:

1.A 1 cell input formula: =RANDBETWEEN( 1, 9)

Generate a divisor between 1 and 9. The formulas are all ready, but they need to be hidden.

2.B 1 cell input formula: = rand between (1, 9) * a1&; "& Peter;" & ampa 1 & amp； "="

This is the final formula.

3. Copy cells A 1 and B 1 five times to the right, with a cell in the middle.

4. Pull down 20 rows with a row height of 34.5.

5. Hide the columns that generate dividends.

Print preview of two digits 100 that can be divisible by one digit:

To sum up, it is relatively simple to work out a set of exercises by using function formulas. You only need to master these formulas skillfully to solve your own problems. It can be seen that the function of Excel as an office tool is very powerful.