48-Question Excel MCQ Workbook
Budget: ₹600 – ₹1,500 INR
I have the complete wording for 48 multiple-choice questions and now need them laid out in a single Excel workbook. Every question must appear exactly once—no more, no less—so the final file should contain 48 fully formatted items.
Formatting & Look
Some questions will need their stems or key phrases in bold, and a few answer options should be colour-coded to highlight correct or related choices; others can stay plain. Use Excel’s native cell formatting for this—no images, please—so the text remains editable.
Interaction & Validation
• Each question must accept more than one selected answer when required.
• A simple shuffle feature that randomises the order of answer options every time the sheet is opened (or via a clearly labelled macro button) is essential so that learners can’t memorise positions. VBA or any Excel-native technique is fine as long as it runs in the default security settings of Excel 2016 and later.
• Keep the answer key on a hidden or very clearly separated tab.
Deliverables
1. XLSX file with 48 questions, answer options, and the hidden key.
2. Any VBA code (if used) clearly commented inside the workbook.
3. A short read-me inside the file explaining how to reshuffle answers and reveal the key.
Completion is accepted once the workbook opens without errors, all 48 questions are present, formatting matches the brief, multiple answers can be ticked where specified, and the shuffle works reliably.
Formatting & Look
Some questions will need their stems or key phrases in bold, and a few answer options should be colour-coded to highlight correct or related choices; others can stay plain. Use Excel’s native cell formatting for this—no images, please—so the text remains editable.
Interaction & Validation
• Each question must accept more than one selected answer when required.
• A simple shuffle feature that randomises the order of answer options every time the sheet is opened (or via a clearly labelled macro button) is essential so that learners can’t memorise positions. VBA or any Excel-native technique is fine as long as it runs in the default security settings of Excel 2016 and later.
• Keep the answer key on a hidden or very clearly separated tab.
Deliverables
1. XLSX file with 48 questions, answer options, and the hidden key.
2. Any VBA code (if used) clearly commented inside the workbook.
3. A short read-me inside the file explaining how to reshuffle answers and reveal the key.
Completion is accepted once the workbook opens without errors, all 48 questions are present, formatting matches the brief, multiple answers can be ticked where specified, and the shuffle works reliably.