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

​This 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 on button to the right to download the quiz spreadsheet shown in the video and then try it out yourself!

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?

We have placed cookies on your device to help make this website better.

I'm fine with this

We use cookies to give you the best online experience.

Please let us know if you agree to all of these cookies.

Some of the cookies we use are essential for the site to work.

We also use some non-essential cookies to collect information for making reports and to help us improve the site. The cookies collect information in an anonymous form.