1 min readfrom Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community

Creating a Quiz from an Excel/Google Sheet

I am studying for an exam and I'm going over this excel document with multiple choice questions and their answers. The thing is it's a little bit of a pain to read over these in this format as there is 600+ questions I have to go over.

I was wondering if anyone knows how I can quickly turn this document into a quiz format using google forms or something similar.

I started doing it manually and immediately gave up.

As you can see there's a column (G) for the question, columns (H-K) for answer choices, and a column (L) for the answer in form of A,B,C,D.

I'm a complete noob with excel, if anyones willing I'd even pay for someone to do it for me, but I'd like to try myself first lol.

submitted by /u/Nemoj-da-seres
[link] [comments]

Want to read more?

Check out the full article on the original site

View original article

Tagged with

#Excel alternatives for data analysis
#natural language processing for spreadsheets
#generative AI for data analysis
#Excel compatibility
#Excel alternatives
#financial modeling with spreadsheets
#google sheets
#rows.com
#Quiz
#Excel
#Google Sheet
#Multiple Choice Questions
#Answers
#Question Format
#Google Forms
#Answer Choices
#Columns
#Document
#Manual Entry
#Study
Creating a Quiz from an Excel/Google Sheet