6] Now, we have to enter a formula to calculate the score ... “Protect sheet,” create a password and click OK. This is how you can create an automated quiz in MS Excel by using formulae.