How to generate questions randomly in Excel?

Question

excel

There is an excel survey and it is necessary that the questions in it are given out randomly, which part is responsible for this, otherwise I have no idea
. Also, I can’t view the code, it gives an error.

All that is

Error

Answer 1

to issue questions randomly, you need to maintain a "bank" of questions (an array of objects) - where each question is represented as an object that contains the text of the question, the correct answer, incorrect answers, you also need a bank of answers (a simple array), at the end, compare the answers with the questions and calculate the correct ones .
Only one form needed