Unless you can have multiple correct responses, I wouldn't use checkboxes. I'd
use optionbuttons. When you select one of a group, the others won't be
selected.

If you want to try, you could use this from Debra Dalgleish's site:
http://contextures.com/xlForm01.html

Then you could used the linked cell to return the user's response.

In the second sheet, you could add your correct responses for each question and
then just compare one cell with the other.

And then count the number of correct.



Pietro wrote:

Hi all,

I have put a sample of an exam on an excel sheet,the exam is composed of
20 questions,where the auditee sould select A,B,C or D,I have inserted check
boxes in front of each option.
I have put the same sample in the second tab with the answers,now i want
that if user selects the correct answer in sheet1,that corresponds with the
answers in sheet2,to add 1 to the cell K20..
Does it make sense?

--

Dave Peterson