How to create a Quiz in Excel. 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.