To add password protection to sheet 2, right-click on it, select “Protect sheet,” create a password and click OK. This is how you can create an automated quiz in MS Excel by using formulae ...