How to make random roll call with excel

Open Excel table

Please click to enter a picture description.

Select the roll call cell

Please click to enter a picture description.

Input formula: = index (a: a, rand between (1, 8))

Please click to enter a picture description.

return

Please click to enter a picture description.

A person's name will be displayed

Please click to enter a picture description.

Some computers press F9, and some press Fn to randomly call the roll.

Please click to enter a picture description.