How to put test questions then student answers and get % correct

[Guest]

I need to make a sheet with test questions and answers. Then I need to put
in all students and their answers. Afterwards I need it to caluate the
percentage that was correct. Can anyone help?

 

[Guest]

How are questions distributed to students? And returned to you?

Do the questions have multiple choice answers?

If Yes, then you could have a table of questions and correct answers and use
VLOOKUP to check a students answer, putting 1 if correct, 0 if incorrect.
Then use SUM to get a student's mark and then calculate %.

The multiple choice selections for a question could be done using Data
Validation.

HTH

 

[Guest]

Assuming student names in column A, and column B their scores, and column C
either have "y" for correct answer, "n" for wrong answer

In D2: =COUNTIF(C2:C10,"y")/COUNTA(C2:C10)