Here, we will create all multiple choice questions in sheet 1 and make an answer sheet in sheet 2. To automate the quiz, we will write formulae in sheet 2. Let’s see the process.