Have a go at the the quiz created by Miss Goodwin on excel by downloading the file on the link below:
HERE
Today, I'd like you to start making your own quiz on excel. This can be on music, pictures, movies, apps, footballers....anything really!
Watch the video below on how you can use the IF formula in excel to automatically tell the person whether they have got the question right or wrong:
HERE
Today, I'd like you to start making your own quiz on excel. This can be on music, pictures, movies, apps, footballers....anything really!
Watch the video below on how you can use the IF formula in excel to automatically tell the person whether they have got the question right or wrong:
Here is the formula I used in the video above:
=IF(A14="Gareth Bale","CORRECT","WRONG")
As you begin to build your quiz, it is really important to include conditional formatting to make it more visually appealing. You should also try to line up the images and cells beneath where you want the participant to add their answers.
Good luck!
No comments:
Post a Comment