Check your quiz results

Microsoft Forms provides a rich grading workflow that enables you, as the author, to efficiently award points per question to students and provide feedback in a number of ways. You can export quiz results to Microsoft Excel for more in-depth analysis and charting, as well as delete or print a summary of all responses.

View summary information for your quiz

After you create your quiz, adjust its settings, and share it with others, it’s time to view the results. In Microsoft Forms, open the quiz for which you want to review the results, and then click the Responses tab.

Responses tab for a quiz

Across the top, you’ll see real-time summary information about your quiz, such as number of responses, average score, and quiz's current status.

Next to each question, you’ll see the number of responses and a colorful chart that shows the distribution of responses across all of the possible answers.

1. Review answers for each question

Click Review Answers to provide points and feedback.

On the People tab, you can see individual details for each student, such as time it took to complete your quiz, number of points earned, and the option(s) your student selected.

Review answers page

In this view, you can grade all questions for one student, then do the same for subsequent students. Click the arrow next to a student's name to jump to the results of another student. You can also click the left and right arrows to toggle through the result details of the other students.

To provide general feedback for a student, click the feedback icon Feedback icon and enter feedback in the text box.

Enter feedback for a responder

To provide feedback for a particular question, click the feedback icon Feedback icon to the right of points, and then enter feedback in the text box.

Enter feedback for the response to a particular question

Click the ellipses button (...) to delete all responses for a particular student, print all responses for a particular student, or post scores.

Delete, print, and post scores options in Microsoft Forms

Learn more about printing forms.

Note: Deleting a response cannot be undone.

On the Questions tab, you can see each question and average points earned for that question.

Review quiz questions

In this view, you can grade one question across all students, then do the same for the subsequent questions. Click the arrow next to each question to jump to another question's details view. You can also click the left and right arrows to toggle through the details of other questions.

2. Post scores

When you're ready to share your feedback and points to students, click Post scores in the Responses tab.

For each student, you can see the status of his or her quiz (e.g. graded) and number of points earned. If you want to post the scores of all students, click the check box to the left of Name in the Name column. To post individual scores, click the checkbox to the left of each student's name.

Review, select, and post scores

Click Post scores.

Once you post scores, you can go back to your quiz to review your results and feedback. Students can view their scores and feedback by launching the form.

Analyze your quiz results in Excel

You can easily view all of the response data for your quiz in Microsoft Excel. Click Open in Excel on the Responses tab.

Each question in your quiz is a column and each response becomes a row in the Excel workbook. The first four columns display the start time and completion times for each response, and the email address and name for each student. The subsequent columns display total points, quiz feedback, grade posted time, quiz questions, points for individual questions, and feedback for individual questions.

Excel workbook displaying quiz results

Notes: 

  • Any changes you make to the quiz data in Excel won’t modify the content of the response table.

  • Names and email addresses of anonymous responders won’t be displayed if you allow your quiz to accept anonymous responses.

Got feedback on Microsoft Forms?

We'd love to hear from you! In the upper right corner of the Microsoft Forms window, click More Options (...) > Feedback. You can also visit the Microsoft Forms User Voice site to provide suggestions and vote on ideas others have already submitted.

Expand your skills
Explore training
Get new features first
Join Office Insiders

Was this information helpful?

Thank you for your feedback!

Thank you for your feedback! It sounds like it might be helpful to connect you to one of our Office support agents.

×