Groups of option buttons in our fun quiz! Have a go and let us know!

Groups of option buttons in our little quiz! How many questions did you get right?

Groups of option buttons: Excel iconThis week’s hint and tip is slightly different, we are bringing you a Quiz! This quiz has been created using groups of option buttons and you can see how they are used in this post. Option buttons aren’t covered in our courses yet, but they may well be in the future. Meanwhile we wanted to create a fun post to let you know more about them.


Our quiz using groups of option buttons (scroll down for the quiz spreadsheet!)

In the video below we make use of option buttons in a group. The worksheet is a quiz giving 3 questions with the total score being shown at the bottom of the sheet turning green if a person gets all 3 right.

We’ve hidden column B which in a cell for each question holds the correct option number per question. We’ve also hidden column E which has an IF statement to show “correct” or “incorrect” but you can see the formula behind cell C17 which counts the correct answers.

The 3 questions are all on topics covered in our 3 Excel courses Basic, Intermediate or Advanced.

We are using the IF function and COUNTIF function in this worksheet and have hidden redundant columns and rows and password protected the sheet.

It’s a good way of reviewing on line various topics on a virtual training course.

Have a go at the quiz by downloading the spreadsheet below the video and see if you get all 3 right; they’re not that tricky.


A video to demonstrate option buttons in the quiz

The video below shows you how the quiz works and how you can tell if you get the answers correct. We hope that you find the video useful and enjoy learning about it!

Take a look below at the video to find out more and then try it out on your own computer!

Click here to download the quiz spreadsheet shown in the video and then try it out yourself!

Feel free to send your comments or questions to us at Alternatively, post a comment saying how many you got right first time.

We hope you have enjoyed this small quiz using groups of option buttons. Why not take a look at our previous hint and tip on Data Validation and its use in Excel?