Just ignore the grid lines, we will remove those later. You can add carriage returns, but that will not be necessary. Next, move over to column B to start typing your questions. , and I skipped a row between each of the numbers.
Type your questions and answers, or type the questions and answers you see below.Īfter you have typed your questions and multiple choice answers, scroll back to the beginning of the sheet and put the title of your quiz in cell The questions are not necessary, but I found that it helped me to have them on the sheet. In my sample below, I scrolled over to column heading When you have composed your quiz questions and answer selections, open an Excel workbook and scroll past where the screen would be displayed when the Excel workbook opens. Show what right and wrong answer choices would look like. Shows what the drop down list would look like and questions The image below is a sample of what the quiz would look like. Make a review quiz in Excel and format the cells so that right answer selections are a different color from wrong answer selections.
Using Conditional Formatting and Drop-Down Lists
0 kommentar(er)
