UrTrix - UnRevealed Tricks

We have created a simple quiz in Google Forms that has 3 questions and each correct answer gives you 10 points. The maximum score that can be attained in the quiz in thus 30 points. When someone takes the quiz and submits the form, the responses are recorded in a Google Sheet that is set as the response destination for your Google Form. There’s something interesting here as well. If the associated form is a quiz, Google Sheets will automatically add an extra column in the response sheet titled “Score” and this column will be populated with the total marks obtained by respondent in the quiz. Convert Quiz Score to Percentage A teacher may want to calculate the percentage score obtained by students in the Quiz and assign grades accordingly. This can be easily done with the help of Array Formulas in Google Sheets but before we get there, let’s see how we can convert the quiz score (say, 20/30) into a percentage. Extract the Score Obtained There are at least three way to extr...