E
EXCEL QUIZ
Hi,
I want to create a quiz in excel like the following.
In cell a1) question with a yes or no drop down
in cell b1) if they answered yes then correct (which i know how to do with a
formula)
In cell c2) the answer if they get it correct (I also know how to achieve
this)
wht I DONT know how to do is to enter the formula so everything is blank
then it populates based on the answer.
I want to create a quiz in excel like the following.
In cell a1) question with a yes or no drop down
in cell b1) if they answered yes then correct (which i know how to do with a
formula)
In cell c2) the answer if they get it correct (I also know how to achieve
this)
wht I DONT know how to do is to enter the formula so everything is blank
then it populates based on the answer.