You can select any cell to calculate the score. =COUNTIF(C2 ... This is how you can create an automated quiz in MS Excel by using formulae. Let us know if you have any questions.