Access the MCQ
In the list of masters, click on the master for which you wish to export the MCQ. The master opens in the word processor. In the left-hand menu, click on the button to access the MCQ.
For more information, see the full articles:
- How to access the masters?
- How to create an MCQ?
Export the MCQ
Click on the button, the list in .xlsx format will be downloaded immediately to your browser.
Formatting the table
When the download is complete, open the file with your usual spreadsheet program (usually Microsoft Excel), then follow the steps below:
- Click on 'Enable changes' to format the table.
- Click on the button at the top left of the sheet to automatically select all the cells.
- Position the mouse between two columns: the cursor should appear as a black cross.
- Double-click: the width of all columns is automatically adjusted
- Apply the formatting of your choice (borders, headers, merge cells...)
Understanding the results
The table shows the information from the MCQ, in the same order as it appears on the screen. The information is as follows:
- Question display condition(s)*
- Name of the question
- Mandatory** answer
- Several answers possible**
- Answer
- Pre-checked answer**
- Context(s) provided by the answer* (if applicable)
- Context(s) which exclude(s) the answer***
- Code of the response's merge field(s)*** (if applicable)
* If no context has been defined, the corresponding cell remains empty.
** Corresponds to the corresponding tick box in the right-hand column of the MCQ.
*** If no merge field has been set for the answer, the cell remains empty.
NB: The table displays one line per answer. The questions and their properties (compulsory question, several possible answers) are therefore, by default, repeated as many times as they contain questions.
For better readability, we recommend that you merge the cells, as we have done in the example above.