How to create a questionaire with excel

  • Thread starter Thread starter Frans
  • Start date Start date
F

Frans

Hi,

Can anyone tell me how to create a questioniare with excel where it can
indicate to the user if the answer they've provided to the question is
correct or wrong?
Thanks
 
A1: user answer
B1: correct answer

C1: =A1=B1

TRUE = match, FALSE = no match

Or, if case sensitivity is an issue, use:

=EXACT(A1,B1)

HTH
Jason
Atlanta, GA
 
Back
Top