Create a Basic Quiz in Excel

Creating a quiz or some type of user interactive cells that make a worksheet into a form is not ideal for Excel, but it still is possible. Well almost any use of Excel is possible depending on how much time you'd want to spend. This video will cover a basic on how to use Excel to create quizzes or a basic test to send out. I will show 3 examples. The constraint is that this uses only a multiple choice - single answer approach.
Example 1 (04:05), Example 2 (06:21), Example 3 (10:25) #excel
#msexcel
🔔 SUBSCRIBE to my channel ➜ goo.gl/wN3c3p
🏫 Excel Training ➜ www.exceltraining101.com/p/tr...
📚 Excel Books & Tech Gear ➜ www.amazon.com/shop/dough
⚙️ Tools: Screencasting ➜ techsmith.z6rjha.net/5Qe53
⚙️ Tools: Microsoft Office ➜ microsoft.msafflnk.net/rKL0G
⚙️ Tools: TubeBuddy ➜ www.tubebuddy.com/et101
📝 This description may contain affiliate links and we'll receive a small commission if a purchased is made using the links (but at no additional cost to you). It'll support the channel and so more videos like this can be made. Thanks for your support!
🎁 If you find these videos useful and want to support my channel go to www.buymeacoffee.com/dough
#excel
#msexcel
#doughexcel
~-~~-~~~-~~-~
Please watch: "Convert Table in a PDF File to Excel"
• Convert Table in a PDF...
~-~~-~~~-~~-~

[@simch8507]

Very useful info...thanks a lot...i was searching for test preparation sample quiz for my daughter..i'll give 10/10 for this video

[@excelisfun]

Thanks - cool video!

[@davitsk1]

Great video, thanks!. Very usefull for my exam.

[@stevesullivan457]

Very Interesting Doug

[@martad3920]

You saved me thank you🙏❤️

[@DougHExcel]

You’re welcome 😊

[@cavazoma]

If we pick the second option with color “conditional formatting” is there a reset option once you go through the quiz? To return the spreadsheet back to blank?

[@red_shadowkid9012]

b stand for black and blue you could have used any color but good vid man keep up the good work

[@DougHExcel]

Hi zack barbara, thanks for the comment!

[@dyanzzz]

can you share spreadsheet for this? thanks

[@owainedwards2327]

That was really helpfull

[@DougHExcel]

Thanks Owain Edwards, glad it helped!

[@samarthambalkar8761]

IT IS VERY USEFUL INFORMATION THANK YOU SO MUCH SIR

[@DougHExcel]

Most welcome

[@L_Jeffe984]

Awesome video. i do have a question for you. How do you get word wrap in a Group Box? I'm finding myself to have to widen the Group Box instead of the text wrapping to the next line.

[@DougHExcel]

I didn't find an option in the group box setting...but you may have better luck with the mrexcel.com forum to ask!

[@alexbraden5]

Where is Flubaroo for Excel?

[@idkman7483]

can anyone explain t me why the first method doesnt allow number as the aner?

[@DougHExcel]

Hi Idkwonder 8s, try to post on the mrexcel.com forum!

[@idkman7483]

@@DougHExcel thanks but its ok i managed to do it. Man it was ferausterwting cuz my teacher wasnt btohered so i had to just go solo and try remembering the past :D so thanks for replying atleast

[@papayaman123]

tricked me twice!