Excel how to use formulas to arrange the duty table, as shown in the figure below.

1.？ Click any cell to activate the ribbon, as shown:

Please click to enter a picture description.

1.？ Click the formula ribbon and click the insert function in the function library, as shown below:

Please click to enter a picture description.

1.？ Randomly generate integers Select the RANDBEWEEN function to ensure the randomness of the number interval, and set the value to 1-5, as shown in the figure below:

Please click to enter a picture description.

1.？ Then enter the formula =CHOOSE(RANDBETWEEN( 1, 5), "Zhang Lei", "revolution", "seed", "rainbow" and "Xiao Qiang") in the name cell, as shown in the figure:

Please click to enter a picture description.

1.？ The effect is as shown in the figure:

Please click to enter a picture description.