Home>Blogs>VBA>Exam Application Form with Timer
Exam Application form
VBA Templates

Exam Application Form with Timer

Exam Application form useful for Training test or other knowledge test in an organization. We have given User ID and Password option to login the form.

Visit our YouTube channel to learn step-by-step video tutorials

Youtube.com/@PKAnExcelExpert

Watch the step by step video tutorial:

Exam Application Form with Timer

User can login using User Id and Password in Login form.

Login Form
Login Form

After logged in, Start the Exam-

Start the Exam
Start the Exam

Select an answer form 4 different options. There will be a running timer. Answer has to be submitted in given time.

Question form
Question form

In this template file there are 4 hidden worksheets. Admin can use these worksheet as given below.

1.Setting:

In the Setting worksheet admin can select the setting for

  • Password Required: Password is required or not to logged in this application, select Yes or No.
  • Question to be asked: How many questions to be asked. Put the number here.
  • Show Timer: Timer is required or not, select Yes or No.
  • Random Shuffle: If you want to shuffle the questions sequence randomly then select Yes otherwise No.
Setting worksheet
Setting worksheet

Questions:

In this worksheet, Admin can enter the Questions, Options, Correct Answer, Score and Allowed Time (In Sec).

Questions Worksheet
Questions Worksheet

Answer Sheet:

This worksheet will be filled automatically. Admin must be make sure, this should be blank before sending to the employees. Keep only headers.

Answer Sheet
Answer Sheet

User List:

In the User list worksheet, Admin can manage the list of User Id and Password of the employees.

User list worksheet
User list worksheet

You can consolidate the data from multiple files of Answer Sheets form different employees using PK’s Utility Tool V2.0

Click here to download PK’s Utility Tool 2.0

Click on the File Manager button.

File Manager in PK's Utility Tool
File Manager in PK’s Utility Tool
  • Select the folder wherein you have kept all the files.
  • Select all the excel file
  • In Data Consolidation frame, select Sheet Name option and put “Answer Sheet” in text box.
  • Click on OK
  • Data will be consolidated into in Excel file.
File Manager
File Manager

 

PK
Meet PK, the founder of PK-AnExcelExpert.com! With over 15 years of experience in Data Visualization, Excel Automation, and dashboard creation. PK is a Microsoft Certified Professional who has a passion for all things in Excel. PK loves to explore new and innovative ways to use Excel and is always eager to share his knowledge with others. With an eye for detail and a commitment to excellence, PK has become a go-to expert in the world of Excel. Whether you're looking to create stunning visualizations or streamline your workflow with automation, PK has the skills and expertise to help you succeed. Join the many satisfied clients who have benefited from PK's services and see how he can take your Excel skills to the next level!
https://www.pk-anexcelexpert.com