Others

How to Assign Scores to Choice Answers in Microsoft Forms

Maira Mehtab Sep 21, 2026 869 views

Question details

The user wants to know if they can assign custom numerical values (such as 3, 2, and 1) to specific multiple-choice options in Microsoft Forms to automatically calculate a total score upon submission.

Product: Microsoft Forms
Device & OS: not provided
Scenario: Creating a weighted survey or assessment where different choice answers carry different point values.
Observed behavior: Microsoft Forms standard choice questions do not natively support assigning custom numerical values to individual options for automatic total score calculation.

Before you start

Before proceeding, determine whether you need a simple quiz with correct/incorrect grading (which Microsoft Forms natively supports) or a weighted survey requiring custom point values for each choice (which requires a workaround like Power Apps or Excel).

Solution 1

Understand Native Microsoft Forms Quiz Limitations

Microsoft Forms allows assigning points to a whole question, but not custom weights to individual choice options.

If you use the 'Quiz' feature in Microsoft Forms, you can assign a total point value to a question. However, this only applies if the user selects the exact correct answer. It does not allow you to assign a '3' for option A, a '2' for option B, and a '1' for option C.

Because of this limitation, creating a weighted questionnaire natively in Forms is not currently possible.

Open your Form

Navigate to Microsoft Forms and open the form you wish to edit.

Check Quiz Settings

Ensure you have created a 'New Quiz' rather than a 'New Form' if you want any native scoring capabilities.

Review Choice Options

Click on a choice question. Notice that you can only mark an option as the 'Correct Answer' and assign a total point value at the bottom of the question, rather than assigning individual values to each choice.

Solution 2Recommended

Build a Custom Scoring Application with Power Apps

Create a custom survey app in Power Apps where each option has an assigned numerical value and totals are calculated automatically.

Solution 3

Seek Implementation Guidance in the Power Platform Community

If you need a complex workflow or specific implementation details, community experts can provide tailored guidance.

Free Microsoft Office alternative

Need a Powerful Office Suite? Try WPS Office

While handling complex automated surveys might require specialized enterprise tools, your everyday document processing, spreadsheet analysis, and presentations can be handled effortlessly with WPS Office. Enjoy a comprehensive suite that is highly compatible with Microsoft formats without the heavy subscription costs.

1. Download and Install: Visit the official WPS website to download the free version of WPS Office and install it on your device.
2. Open Your Exported Data: If you exported your Microsoft Forms results to Excel, you can open that .xlsx file seamlessly in WPS Spreadsheet.
3. Analyze the Results: Use WPS Spreadsheet's built-in formulas like VLOOKUP or nested IF statements to manually calculate your weighted scores from the raw survey data.

Highly compatible with Microsoft Word, Excel, and PowerPoint formats.Process your exported survey data easily using advanced formulas in WPS Spreadsheet.Lightweight and fast-loading on Windows, Mac, Linux, and mobile devices.Includes a rich set of free templates for quizzes, assessments, and reports.

microsoft office alternative - wps office

Frequently Asked Questions

Can I use branching in Microsoft Forms to calculate custom scores?

No. Branching allows you to direct users to different questions based on their previous answers, but it does not calculate custom numerical scores or assign varied weights to specific choices.

Does a Microsoft Forms Quiz allow point values?

Yes, but only for marking an entire question as correct or incorrect. You can assign a total point value to the question (e.g., 10 points for getting it right), but you cannot assign distinct point values (like 1, 2, 3) to different multiple-choice options within the same question.

How can I calculate scores if I don't want to use Power Apps?

You can use Microsoft Forms to collect the answers without scores, export the results to Excel, and then use spreadsheet formulas (like IF statements or VLOOKUP) to assign values to each choice and calculate the totals. However, this method will not show the respondent their score immediately upon submission.

Office Quick Solutions