how to make excel a learning tool for foreign language learners

The purpose of creating this thread is to help me make a "game" for students that can:

1. generate words randomly (in A1:A5) from a specific set of words (sheet2);
2. write answers (in B1:B5) and check whether the answers were correct or not (C1:C5);
3 create a button that generates the words again.

Im just starting to learn how use excel and i have reading a lot to solve my problem however, i cant understand the core concept of vba/acros . Threads in this site with the almost the same problem cant answer my problem. Thus, failure seems to be my fate in this quest. That is why im seeking help to you people.

i have tried my own (=INDEX(Sheet1!$B:$B,RANDBETWEEN...) and my biggest problem is when i try to put my answer, it randomize again. that is why i think, macro/vba is the answer. thank you for future remedy

i will start reading this.. thanks

wow, it did answer my 1. and 3. questions.. ill try tweakin it a little to solve my no. 2 question. if you're able to find thread to answer it, it'll be a big help :D

tigeravatar, thank you for answering my questions :D BIG HELP for us.

yeah, im thinking that i should write my answer in 2nd column and see whether im right in column 3, and find my overall records in sheet 3. that way, i can assess where i shud study more. by the way, wat u did really helped me, i just adjusted the question from 20 to 10. (and im proud i did it w/out help :D )