Is there a way to enter two possible answers for quiz in excel?

D

Dani

Member
Joined
May 14, 2008
Messages
371
Reaction score
0
Points
16
Is there a way to enter two possible answers for quiz in excel?
Hey there. I'm creating a self-assessing quiz in excel for my spanish class to study vocabulary, and I'm wondering if there is a way to insert a function to accept two possible answers. For example:

If the question says to translate "How are you?" to spanish, I want the program to accept "¿Qué tal?" and "¿Cómo estás?"

All of the tutorials I've looked at have been way too complicated. Please make any explanations as simple as possible!

Gracias :]
 
Sure.

I assume this is multiple choice-type quiz? Where they'll pick an answer from a list of choices? And somehow, indicate their answer by putting an X in the box next to their choice? That's how I envision it.

=IF(what is the criteria, what to do if true, what to do if false)

So if "¿Qué tal?" was in cell B5 and "¿Cómo estás?" is in cell B6, and "¿Cómo se yama?" was in B7 and "¿Que pasa?" was in B8 (for example...my high school Spanish is very very rough),

and the Xs would be in column A next to the answers, the IF would be:

=IF(OR(A5="x",A6="x"),"Correct","Sorry try again")

The OR(option1, option2, option3, etc.) is always separated by commas, any text needs to have "double quotes", and the (parantheses) need to open and close each fuction (so the OR has open/close, and the IF has open/close)

You can put other words in place of "Correct" and "Sorry try again", but they would also need to be surrounded by the "double quotes".

Good luck!
 
Back
Top