EXCEL 隨機生成數字1~10

=CHOOSE(INT(RAND()*10+1),1,2,3,4,5,6,7,8,9,10)
如果要五個選項，就改這樣
=CHOOSE(INT(RAND()*5+1),1,2,3,4,5)

如果要字串
=CHOOSE(INT(RAND()*5+1),"A","B","C","D","E")