Create a Sheet Structure for Random Password Generator At first, you need to create a basic structure of your sheet to generate a random strong password.

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.