Others

Can Microsoft Forms Quizzes Score Each Section Separately?

Natalie TaylorNatalie Taylor Nov 3, 2026 870 views

Question details

The user wants to know if it is possible to generate independent scores for individual sections or topics within a single Microsoft Forms quiz.

How to Handle Separate Section Scoring in Microsoft Forms Quizzes
Product
Microsoft Forms
Device & OS
not provided
Scenario
Creating a comprehensive quiz with multiple topics where the creator needs to evaluate and report scores for each specific section independently.
Observed behavior
Microsoft Forms currently calculates only a single total score for the entire quiz and does not natively provide a breakdown of scores by individual sections.
Before you start

Since Microsoft Forms lacks native section-level scoring, determine whether it is more important to keep all questions in a single link or to provide immediate section scores to respondents.

Solution 1Recommended

Export Responses to Excel and Calculate Section Scores Externally

Keep your quiz as a single form and use spreadsheet software to manually calculate the scores for each section after respondents submit their answers.

This is the best method if you want to provide a seamless experience for the respondent by keeping all questions in one single quiz link.

1
Navigate to Quiz Responses

Open your quiz in Microsoft Forms and click on the 'Responses' tab located at the top of the page.

2
Export Data to Excel

Click the 'Open in Excel' button to download a spreadsheet containing all the detailed responses and individual question scores.

3
Add Section Total Columns

Open the downloaded file in your spreadsheet software. Insert a new column for each section you want to score.

4
Calculate Using SUM Formula

Use the SUM function in your new columns to add together the individual point values for the specific questions that belong to each respective section.

Export Responses to Excel and Calculate Section Scores Externally
Delayed Feedback: Using this method means respondents will not see their individual section scores immediately upon submission, as you have to calculate them after the fact.
Free Microsoft Office alternative

Easily Analyze Exported Quiz Data with WPS Office

Since Microsoft Forms requires you to calculate section scores externally, you need a reliable spreadsheet tool. WPS Office is a free, lightweight, and highly compatible suite that perfectly opens Excel exports from Microsoft Forms.

  1. 1. Open Your Quiz Export: Download the response data from Microsoft Forms and double-click to open it instantly in WPS Spreadsheet.
  2. 2. Organize Your Data: Easily insert new columns and color-code your cells to visually separate the different quiz sections.
  3. 3. Apply Scoring Formulas: Type '=SUM(' and select the specific question columns for a section to instantly calculate the independent score.
100% compatible with Microsoft Excel (.xlsx) files exported directly from Microsoft Forms.Use powerful built-in formulas like SUM and IF to quickly calculate quiz section scores.Free to use, lightweight on system resources, and offers a highly familiar user interface.
microsoft office alternative - wps office

Frequently Asked Questions

Will Microsoft Forms add a feature to score sections separately?

This has been a highly requested feature by educators and professionals. While it is not currently available, you can submit this idea or vote for it on the official Microsoft Forms feedback and UserVoice portals.

Can I use branching logic to separate scores in Microsoft Forms?

No. While branching allows you to direct respondents to specific sections based on their previous answers, Microsoft Forms still compiles all earned points into one single total score at the end of the quiz.

Is there any way to show respondents their section scores immediately?

Within a single quiz, it is not possible. To provide immediate scores per topic, you must split your content into multiple separate Microsoft Forms quizzes.