I have been asked to do a form in Excel and one portion of the form requires
a simple Yes or No answer. The best way of doing this I thought was giving
the person who will be completing the form an option button to select either
Yes or No. (There are approx 6 questions requiring only Yes or No answers)

I am not an expert in Excel at all and need some advise here...

How do I put in the option button in for each question to be only yes or no
and how can I assign a value of 1 to the Yes answers that will pull through
to a summary sheet refelcting the answers given?

Thanks
Pieter