Trying to Create a Template for Scoring a Test

So I'm trying to create a template where I have the questions for a test, an answer key, and then student answers and scores in the following columns. It seems like it will be a fairly simple solution, but I just can't seem to find the correct formula for what I'm trying to do. I have attached the spreadsheet here. Sample Test.xlsx

What I'm trying to do is first compare each student's answers to the answer key (the answers to the questions are always either "Yes" or "No"). Then, if the student answer matches the answer key, I want a score of 10 to be generated in the cell next to their answer for that particular question. If the answers don't match and they are wrong, I want it to generate a zero. Can anyone help me with this?

Put this formula in D2:

=($B2=C2)*10

and copy down. then copy those formulae across to columns F and H.

Hope this helps.

Pete

Originally Posted by Pete_UK

Put this formula in D2:

=($B2=C2)*10

and copy down. then copy those formulae across to columns F and H.

Hope this helps.

Pete

Perfect. Thank you!