In its article, we will show you the procedure to create an automated quiz in Microsoft Excel. Here, we will create all multiple choice questions in sheet 1 and make an answer sheet in sheet 2.