scores from test

**Lene** · 08-25-2009, 04:38 AM

Hi

I need help with quiz results.

I'v created a quiz online where I can export the questions and results to excel.
Now I need help to get scores. Each question has only one right answer and will give the user 1 point otherwise the user gets 0 points.

So what I want to know is, is it any way I can set formulas that help me see who has answered correct and who has'nt? If so, how?

Maybe a stupid question but I'm new to excel so does'nt hurt to ask right?

**Lene** · 08-25-2009, 05:35 AM

This is how it looks like when exported to excel (attachment)

**Lene** · 08-26-2009, 03:41 AM

I figured it out

I needed to match fields by using IF or in norwegian HVIS formel. Thanks for help

**anandsietk** · 08-09-2011, 06:25 AM

When I open the worksheet the first question should come on the spreadsheet with 3 options, when he clicks one of the 3 options (a,b,c) second question should popup again with 3 options again when he clicks a,b,or c again another question. This should go for 50 times and at the end his score should appear and also the display the questions which are wrongly answered will it br possible.

thanks in advance

**ellesor_0314** · 08-18-2012, 09:33 AM

hi..i would just like to ask how to make formula to show descriptive grades in equivalent to its numerical grades? Like when the cell contains grade 74 and below that B for "Beginning'' will appear in the next cell,75 to 79 its equivalent is D for ''Developing'',80 to 84 is AP for Approaching Proficient, 85 to 89 is P for Proficient and 90 above is A for Advance

...thanks