6. Creating the IF formula quiz. First decide on a theme for your quiz. Find 10 images that you can use in your quiz and save them to your folder. Now using big box borders create the space for the picture, the question and the answer. Make sure all the column widths are the same by using the select all feature and setting them to 20.
7. Add the images.
Now use the if formula =if(a1="name","Correct","Try Again")
8. Add conditional formatting to change the colour if the word "Correct" is displayed
When you have completed the if formula, add several more questions to your quiz.
Try adding the count if formula to count how many "correct" answers are displayed in the selected range.