With help from a few people here (THANKS), I’ve set up a quiz testing people’s knowledge.
- A random question is entered into cell C5. Automatic Calculation is shut off so C5 will only populate when F9 is hit.
- Users enter their answer in D5.
- Upon entering their answer, the correct answer appears in E5, which appears blank (I say “appears” because it’s actually populated but font is colored to appear blank until D5 is populated).
- Fonts and backgrounds in D5 and E5 are conditional formatted to change color based on correct or incorrect answers.
- Enters an answer in D5. For discussion, let’s say they’ve entered an answer in D5, 20 times. I need this number to display in a cell.
- How many times it’s the correct answer. For discussion, let’s say they’ve answered 15 of the 20 questions correctly. I need this number to display in a cell.
- Show the percent of right answers. A simple mathematical formula in a cell based on the results shown in a and b.
- Lastly, I need a way to “reset” the score allowing users to take the test again and start with a clear score.
