Keeping score on a quiz

[RodneyW]

Good morning. I've set up a quiz, screen shot below, testing knowledge of airport codes. When started, cells D18 and E18 are empty. The user enters their answer in D18. The correct answer appears in E18. If there's a match, both cells are green. If wrong, both cells are yellow. When a user double clicks NEXT, it moves to the next question, clearing out D18 and E18. All works perfectly. If it helps, here's a reference the post as to how I got to where I'm at: Setting up a test for students to get the right answer

Now what I need is a way to do three calculations.

1. Count how many answers the user has submitted. This number will go in J18.
2. Count how many answers are correct. This number will go in cell K18.
3. A simple mathematical formula will populate L18.

Lastly, and I maybe should put this in a different post, but it may be structurally important to ask it now, if someone wants to restart the test and clear scores, clicking Clear Results in N18 should take J18 and K18 back to 0.

Thanks in advance.

 

[dreid1011]

To do the following, make sure "Design Mode" is active:

Then name the button properly:

Right click the button and select Properties.

Change the name (highlighted) from "CommandButton1" to "ClearButton".

 

[RodneyW]

AWESOME! It all works. Thank you so much

 

[dreid1011]

AWESOME! It all works. Thank you so much

You're welcome, and happy to help.