Classroom Survey Results (Middle School students new to Excel) - Step 2

Links Verified: March 20, 2026

Set up a worksheet with Student Name and Survey Answer. Then enter the class responses one row at a time.

Enter Survey Answers in Excel

Next step: count and group the responses.

Try It

1. Type the two column headings.
2. Enter names and answers carefully.
3. Keep spelling consistent for repeated answers.

This project is part of the Excel Classroom Data Projects series.

Next step: Continue to step 3.