How to analyze multiple choice questions in MS Excel?

This short video discusses the process of creating a frequency table and chart from multiple choice questions responses collected through Google From.

[@arshdeepkaur6319]

You saved my life. I couldn’t tell you how happy I was after finding this video

[@dr.pratiksinh.vaghela]

Happy to help. Always welcome 😊.

[@EvenMoreLego]

Perhaps more a general approach if you could use the value in the LHS summary column as what you are testing equality for. And maybe you could get the list of uniques by using unique on the "columned out" table?

[@ogbonnahfrancis7875]

Thank you sir
I have a problem saving the work after the analysis
It is saying errors were detected while saving

[@larysuda--]

So, how to prepare the cell for enter the data for multiple answer?

[@dr.pratiksinh.vaghela]

Data can be retrieved from Google from.