In Part 1, I showed how to configure a SharePoint survey to be used as a quiz.  In Part 2, I will show how to easily "grade" the quiz.  In our case, since we were using it as part of a contest, we will also see how to easily select the winner of the contest.

After you create the survey for the quiz, but before you have users submit their responses, delete any test responses you have created so there are no responses on the survey.  Then take the survey and answer all the questions correctly (hopefully you know what the answers are supposed to be!).  This will make the first recorded response to the survey the "key" or correct answers to the quiz.  We will use this later to grade the quiz.

Once all users have responded to the survey, it's time to do the grading.  Navigate to the survey's "overview" page.  In part 1, we renamed this page so others could not export the questions to Excel, so navigate to whatever you called the previouly named "overview.aspx" page.  In our case, we renamed it to "overview_admin.aspx".

In the survey's toolbar, click on Actions and choose Export to Spreadsheet.  This will export the survey and all responses to Excel, with the questions as column headings and each response as a row.

Find the column of the last question in the survey.  This is not the last column - SharePoint exports two useless columns at the end labeled Item Type and Path (I have yet to find a good use for these).  For example, my survey has 26 questions, so the last question is in column AA.

Now, assuming the correct answers are in the first response (row 2), paste a formula like this in row 3, in the cell after the last column (the Path column):

 =SUMPRODUCT((B3:AA3=$B$2:$AA$2)*(B3:AA3<>""))

For your survey, replace AA in the formula with the column ID of the last question in your survey.

When you paste it in the cell, it will automatically repeat for each survey response.  You should see a number appear for each survey, indicating the number of correct responses.  As a check, the number in row 2 for this column should equal the number of questions in your survey.

That's it! Your quiz is graded.  The name of each user responding is in column A, and their score is in the last column.

To find the best scores, click on the drop down arrow in the new column heading and choose Sort Largest to Smallest.  The person's name in cell A3 has the highest score.  (You would also need to check for ties.)