How to compile survey results in excel

Creating a questionnaire in Excel requires one to understand what he wants to know, ask the question and give the allowance for the respondent to answer.

After coming up with the questionnaire, you can choose to print it out to receive handwritten answers or allow on-screen typed answers.

This is done as follows;

Steps to create a questionnaire on Excel

1. Open your Microsoft excel, and on your spreadsheet click the cursor into cell "A1."

2. In this cell, input the name for the questionnaire.

3. Notice that this will extend to other cells.

Excel questionnaire template

Highlight the font, go to font size and choose the appropriate font, size, and title.

4. Increase the width of the cell to fit the title. Double click the line between columns A and B to adjust fitting the title.

5. In cell "B2." Type "Name" then "Respondent" and on "B3" "Date" to indicate when the questionnaire was taken.

6. Navigate to the "Insert" tab and click the "shape" button.

Press the shift key and click your mouse to draw a line after the "Name" "Date" to give space for the Respondent to fill.

7.

how to create a test in excel

how to create a survey in excel online