Others

Add Correct Answers to a Submitted Quiz and Calculate Scores

Rana GarciaRana Garcia Nov 14, 2026 869 views

Question details

The quiz owner needs to add the correct answers after collecting responses and calculate the percentage of correct answers.

Product
Online quiz platform and WPS Spreadsheets
Device & OS
not provided
Scenario
A quiz was sent and answered before its answer key was configured.
Observed behavior
Responses have been collected, but the correct answers were not set up before submission.
Before you start

Open the quiz with the account that owns it and confirm that you can edit its questions and view responses. Have the correct answers ready, and check whether the quiz platform can export responses to a spreadsheet.

Solution 1Recommended

Add the answer key and check the quiz results

Use the quiz editor to add correct answers, then check whether the platform regrades existing submissions.

1
Open the quiz editor

Sign in to the quiz platform, open the quiz from your dashboard, and select its Edit option.

2
Set the correct answers

Open each question and use its correct-answer or answer-key control to mark the right response. Save the quiz if the editor provides a Save button.

3
Review existing results

Open the quiz's Responses or Results view and compare existing scores with the new answer key. If the platform recalculates after a new submission, check the results again after the next response arrives.

Add the answer key and check the quiz results
Regrading varies by platform: Adding an answer key or receiving a new response does not guarantee that earlier submissions will be regraded. If the scores do not update, check the platform's grading options or calculate them from exported responses.
Calculate quiz results

Calculate Quiz Scores in WPS Spreadsheets

Open exported quiz responses in WPS Spreadsheets, add an answer key, and use a formula to calculate each participant's percentage.

  1. 1. Open the response file: In WPS Spreadsheets, use Open to select the quiz response file exported from your quiz platform.
  2. 2. Arrange the answer key: Put correct answers in B1:D1, question headers in B2:D2, and participant answers in B3:D3 and subsequent rows.
  3. 3. Enter the score formula: In E3, enter =SUMPRODUCT(--(B3:D3=$B$1:$D$1))/COLUMNS(B3:D3), then fill it down alongside the remaining responses.
  4. 4. Format the results: Select the scores in column E and choose Percentage on the Home tab. Check a few results against the answer key.
Calculate scores for previously submitted quiz responsesOpen and edit Microsoft Excel XLSX filesUse familiar formulas and percentage formattingReview and adjust the answer key in one worksheet
microsoft office alternative - wps office

Frequently Asked Questions

Will adding correct answers automatically grade old quiz responses?

That depends on the quiz platform. After editing the answer key, open Responses or Results and check existing scores. Some platforms may require a separate regrading action or may not update earlier submissions.

Do I need a new submission before scores update?

Some platforms may refresh results after a new response, but this is not guaranteed. Check the Results view after the next submission and compare the scores with the answer key.

How can I calculate a participant's percentage in WPS Spreadsheets?

Place the answer key in B1:D1 and the participant's answers in B3:D3. Enter =SUMPRODUCT(--(B3:D3=$B$1:$D$1))/COLUMNS(B3:D3) in E3, then format E3 as a percentage.

Can the spreadsheet formula handle partial credit?

The example formula gives equal credit for each exact matching answer and counts blanks as incorrect. Questions with partial credit or multiple correct selections need a different formula or manual grading.