Consolidating survey results excel

Consolidating survey results excel

If you are a survey respondent and you don't have permission to see other responses, you can click a link to see and edit the text of your own response, including a partial response.

Top of Page The survey questions, number of responses, and percentages appear in the graphical view of summary responses.

The overview page shows a description of the survey and the number of responses.

From the overview page, if you have permissions, you can click links to see a graphical summary of responses or to view a list of all responses.

Note: If you are using a spreadsheet program that is compatible with Windows Share Point Services 3.0, such as Microsoft Office Excel 2007, the exported data includes the results of rating scale questions.

If you export to earlier versions of spreadsheet programs, the results of rating scale questions are not included.

Only the responses that are complete appear in the graphical summary.

A survey response is considered complete after the respondent views every page and then clicks Finish on the last page. The person who set up your survey can specify whether people can view all responses or only their own responses.

If so, chances are you have yet to discover Excel Survey.

You can view individual responses, a list of all responses, or a graphical summary of responses.

You can export your results to a spreadsheet for further analysis if you are using a spreadsheet program that is compatible with Windows Share Point Services.

To see an overview of your survey and its responses, click the name of the survey on the Quick Launch.

If the name of your survey does not appear, click View All Site Content, and then click the name of your survey.

consolidating survey results excel-54consolidating survey results excel-78consolidating survey results excel-51

Microsoft introduced Excel Survey a few years ago along with Office Online.

Join our conversation (50 Comments).
Click Here To Leave Your Comment Consolidating survey results excel.

Comments:

Leave a Reply

Your email address will not be published. Required fields are marked *