Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Creating a survey/quiz
Im trying to create a survey, but have no idea how to calculate the answers:
I've made a list of categories, however there is no definite answers to the questions e.g. It isn't multiple choice for example where I have given 5 possible answers and the person can only pick from these answers, it is left to the person's own opinion. Once I have a decent number of replies I can then sort out the most popular responses. The responses are in text form. Do I have to come up with some numbers that represent each response to a given question or can excel calculate text , finding certain words in answers for example or would Access be better for this type of thing |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Creating a survey/quiz
Use COUNTIF(). Use five cell which counts the number of responses to each
question =Countif(A1:A100,"Answer 1") =Countif(A1:A100,"Answer 2") =Countif(A1:A100,"Answer 3") =Countif(A1:A100,"Answer 4") =Countif(A1:A100,"Answer 5") "tic" wrote: Im trying to create a survey, but have no idea how to calculate the answers: I've made a list of categories, however there is no definite answers to the questions e.g. It isn't multiple choice for example where I have given 5 possible answers and the person can only pick from these answers, it is left to the person's own opinion. Once I have a decent number of replies I can then sort out the most popular responses. The responses are in text form. Do I have to come up with some numbers that represent each response to a given question or can excel calculate text , finding certain words in answers for example or would Access be better for this type of thing |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Creating a survey/quiz
"Joel" wrote: Use COUNTIF(). Use five cell which counts the number of responses to each question =Countif(A1:A100,"Answer 1") =Countif(A1:A100,"Answer 2") =Countif(A1:A100,"Answer 3") =Countif(A1:A100,"Answer 4") =Countif(A1:A100,"Answer 5") "tic" wrote: Im trying to create a survey, but have no idea how to calculate the answers: I've made a list of categories, however there is no definite answers to the questions e.g. It isn't multiple choice for example where I have given 5 possible answers and the person can only pick from these answers, it is left to the person's own opinion. Once I have a decent number of replies I can then sort out the most popular responses. The responses are in text form. Do I have to come up with some numbers that represent each response to a given question or can excel calculate text , finding certain words in answers for example or would Access be better for this type of thing Thanx I'll give it a try |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Simple quiz help | Excel Discussion (Misc queries) | |||
Creating a Quiz... | Excel Discussion (Misc queries) | |||
Quiz... | Excel Discussion (Misc queries) | |||
Correct answers like a quiz | Excel Worksheet Functions | |||
how do i create a quiz using excel? | Excel Discussion (Misc queries) |