Monday, 23 March 2015

Work for Today

You now have 4 lessons to complete your quiz. You should use images, line up cells and change the background; making it as visually appealing as possible.

For those who have already completed a lot of questions, you could add another IF formula which will allow you to accept multiple answers for a particular question and still be correct.

For example, if you had the Spurs badge as your image, but somebody typed 'Tottenham' it would say they were wrong. You can now change this using this formula as an example:

=IF(OR(A1="Spurs",A1="Tottenham"),"Correct","Wrong")

This could be useful in other ways too. For instance, if you have a celebrity quiz, now you can accept full names or surnames as a correct answer. Try to use this formula at some point in your quiz.

No comments:

Post a Comment