Can Microsoft Forms Quizzes Score Each Section Separately?
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.

- 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.
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.
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.
Open your quiz in Microsoft Forms and click on the 'Responses' tab located at the top of the page.
Click the 'Open in Excel' button to download a spreadsheet containing all the detailed responses and individual question scores.
Open the downloaded file in your spreadsheet software. Insert a new column for each section you want to score.
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.

Create Separate Quizzes for Each Topic
Break your large quiz into smaller, individual quizzes for each topic so that each one generates its own independent score automatically.
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. Open Your Quiz Export: Download the response data from Microsoft Forms and double-click to open it instantly in WPS Spreadsheet.
- 2. Organize Your Data: Easily insert new columns and color-code your cells to visually separate the different quiz sections.
- 3. Apply Scoring Formulas: Type '=SUM(' and select the specific question columns for a section to instantly calculate the independent score.

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.




