vrunda
Member
Want to prepare a dynamic question Bank In excel. Sheet 1 will have Questions with 4 options as answers. Sheet 2 will have correct answers for every question.
Requirements is: On sheet 1 Every time excel is opened The questions will change their sequence so on every computer Q1 will not be same, Q2 will not be same i.e. Every question is reshuffled along with its 4choices of answers. Sheet 1 will also contain Submit button that will show result i.e marks of that PC/Student. Submit button will not be for every question.
I hope I m clear
Requirements is: On sheet 1 Every time excel is opened The questions will change their sequence so on every computer Q1 will not be same, Q2 will not be same i.e. Every question is reshuffled along with its 4choices of answers. Sheet 1 will also contain Submit button that will show result i.e marks of that PC/Student. Submit button will not be for every question.
I hope I m clear