It is possible to conduct an exam in MS Excel with the help of Visual Basic or macros. Candidates have to write answers for 20 questions. Till now, we were doing it manually, but now my boss is asking us to conduct it in Excel. Please suggest something.
Thanks in advance,
Ashwini
From India, Kundan
Thanks in advance,
Ashwini
From India, Kundan
Yes, it is possible. You just need to create a form in VB with your questions and then code the other. A simple way is to create a webpage or online test in JavaScript and put it on your server. It is easy; you can even make changes and create many sets. Editing will not be a problem.
From India, Delhi
From India, Delhi
Dear Ashwini,
We have a platform called Violet AMS that will be able to conduct online exams. Please drop me an email at sales@zobble.com if interested. We can host from 20 to 20k users online.
Regards,
Gunjan
9987317744
From India, Mumbai
We have a platform called Violet AMS that will be able to conduct online exams. Please drop me an email at sales@zobble.com if interested. We can host from 20 to 20k users online.
Regards,
Gunjan
9987317744
From India, Mumbai
Yes , its simple. first u need to make master data base of all questions n then connect it with ur server. U can make it with vba code n without vba code. There is 2 option. With vba, without vba.
From India, Gurgaon
From India, Gurgaon
Several Web pages are available for excellent advice on excel. But for that to work you need some level of expertise in excel. you may take help of experts for conducting the examination.
From India, Thane
From India, Thane
Dear Ashwini,
Could you send me any question paper, for example? I will create and send you a copy of the Excel file. (Without VBA help)
1. In sheet 2, you have to write your questions.
2. In sheet 1, some formulas will be used in hidden format and locked so that nobody can access its internal materials.
3. You could send it via email or upload it to your company/organization server.
With VBA:
You will need some codes. Without your question paper, I can guide you on what you want to accomplish.
Regards,
Gaurav Chaturvedi
Sales Analyst
gauravchaturvedi10@gmail.com
+91-9711983398
From India, Gurgaon
Could you send me any question paper, for example? I will create and send you a copy of the Excel file. (Without VBA help)
1. In sheet 2, you have to write your questions.
2. In sheet 1, some formulas will be used in hidden format and locked so that nobody can access its internal materials.
3. You could send it via email or upload it to your company/organization server.
With VBA:
You will need some codes. Without your question paper, I can guide you on what you want to accomplish.
Regards,
Gaurav Chaturvedi
Sales Analyst
gauravchaturvedi10@gmail.com
+91-9711983398
From India, Gurgaon
Engage with peers to discuss and resolve work and business challenges collaboratively - share and document your knowledge. Our AI-powered platform, features real-time fact-checking, peer reviews, and an extensive historical knowledge base. - Join & Be Part Of Our Community.