Create Lucky Draw game in Excel or PowerPoint

I want to create a Lucky Draw Game for the classmates in our school.
There are seven levels in school (F1, F2, ..,F7).
For F1 to F5, there are 5 classes in each form(1A, 1B,..1E).
For F6 and F7, there are 2 classes in each form(6A, 6B, 7A, 7B).
I want to use the random function to display the class and class number. randomly.
For example, 1A04 is displayed in the Excel sheet for class 1A and student with class number 04.
Can Excel do that?

Hello,
Yes, Excel CAN do that.

if you have a list of the 29 Classes in column A, rows 1 to 29, then the following formula should give you a random selection.

Just select the cell where you want the result displayed and copy the below text into the formula bar and press enter. Press F9 to reselect a class.

=INDIRECT("a"&(INT(RAND()*29)+1))