Hi ,
I am working on creating an examination questions in Excel. I want to also build in formulas in the Excel sheet so that the answers will be calculated automatically as the candidates choose the answers.
I have inputed an option button from the froms toolbox beside each answers for the candidate to click to indicate the answers.
Is it possible to calculate the correct answer or wrong answer with a formula when the candidate clicks on the option button ? Is there a formula that I can use ?
Appreciate assistance.