Can Microsoft Forms Quizzes Use Negative Scores? (Solved)
Question details
The user wants to know if it is possible to assign negative points to incorrect answers in Microsoft Forms quizzes.

- Product
- Microsoft Forms
- Device & OS
- not provided
- Scenario
- Creating assessments or quizzes that penalize test-takers for incorrect responses.
- Observed behavior
- Currently, Microsoft Forms only allows question scores to be zero or higher, preventing direct negative scoring.
Log in to your Microsoft account and open the specific quiz in Microsoft Forms where you want to review or adjust the scoring rules.
Current Limitation and Submitting Feedback
Understand the current scoring limitations in Microsoft Forms and learn how to request this feature.
At present, Microsoft Forms requires each question score to be zero or higher. It natively does not support assigning negative points to penalize incorrect answers in quizzes or assessments.
Because this is a frequently requested feature by trainers and educators, Microsoft encourages users to submit their feature requests through official feedback channels.
Navigate to the official Microsoft Feedback Portal for Forms (previously UserVoice) in your web browser.
Use the search bar to look for 'negative points' or 'negative scoring' to see if a similar request has already been made by other educators.
Click the 'Vote' button on an existing request to add your support, or click 'Send Feedback' to detail why your training environment requires negative scoring.

Workaround: Calculate Negative Scores via Spreadsheet Export
Since Forms cannot natively deduct points, you can export the results and use a spreadsheet formula to apply the negative scoring.
Calculate Quiz Penalties Seamlessly with WPS Office
Since Microsoft Forms lacks built-in negative scoring, exporting your results is the best workaround. WPS Office is a free, lightweight suite that offers powerful spreadsheet capabilities, making it incredibly easy to open exported forms and calculate student penalties with full format compatibility.
- 1. Download and Install WPS Office: Get the free WPS Office suite from the official website and install it on your device.
- 2. Open Exported Quiz Data: Locate the Excel file downloaded from Microsoft Forms and double-click to open it instantly in WPS Spreadsheet.
- 3. Apply Grading Formulas: Use WPS Spreadsheet's built-in formulas to deduct points for incorrect answers and finalize your assessment scores efficiently.

Frequently Asked Questions
Can I set a question score to zero in Microsoft Forms?
Yes, you can set the point value of any question to zero. This is highly useful for practice questions, demographic information, or ungraded survey sections within a quiz.
How do I export Microsoft Forms responses to a spreadsheet?
Go to the 'Responses' tab inside your specific form or quiz and click 'Open in Excel'. This will download a spreadsheet containing all submitted answers, times, and current scores.
Is there any Microsoft educational tool that natively supports negative grading?
Currently, standard Microsoft educational tools like Forms and Teams Assignments do not natively support negative grading or penalty marking out of the box. Teachers typically rely on exporting data to spreadsheets to calculate penalties manually.




