creating a survey

[yewande]

hello
i'm new to excel but i have a task to creat a survey using muliply option,
can someone show me how using baby steps?
thanks

 

[Mike H]

Hi,

I think we'd need a lot more information to be of any help what are we
surveying

Support for nuclear disarmament?
Myths propogated by man-made global warming enthusiasts?

I suggest you look here and see if any of these fit your needs

http://office.microsoft.com/en-us/templates/CT101436331033.aspx

Mike

 

[JLatham]

There are a couple of ways to approach this, mostly depending on those
multiple options and how you want to deal with them.

You could use checkboxes and/or radio buttons from the Forms toolbar (View
--> Toolbars --> Forms) and later you can examine the related cells for those
controls to compile the results of your surveys.

Or you could use Data Validation in cells to provide lists for the survey
takers to choose from and later examine those cells to compile the results of
the survey forms.

If you can be a bit more specific about the types of entries, numbers of
choices and things like that, we may be able to offer more assistance.

 

[JLatham]

You might also look at some of these to get ideas, and maybe even adapt one
of them to your needs
http://office.microsoft.com/en-us/templates/CT101436331033.aspx

 

[Mike Middleton]

yewande -

Is there a really really good reason why you want to use Excel?

A better tool for your task may be Survey Monkey
(http://www.surveymonkey.com/).

- Mike
http://www.MikeMiddleton.com