Add Correct Answers to a Submitted Quiz and Calculate Scores
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.
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.
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.
Sign in to the quiz platform, open the quiz from your dashboard, and select its Edit option.
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.
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.

Calculate scores from exported quiz responses
Use a spreadsheet when the quiz platform does not update scores for earlier submissions.
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. Open the response file: In WPS Spreadsheets, use Open to select the quiz response file exported from your quiz platform.
- 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. 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. Format the results: Select the scores in column E and choose Percentage on the Home tab. Check a few results against the answer key.

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.




