[Solved] Macro for random quiz, is that possible?

[DocenteEstresada]

Hello and well met, friends.

I'll expose the project I have currently in my hands: As the title suggests, it's about quizs made in a Calc spreadsheet. The blueprint for the quizs in question is already done and it works quite well (is attached below if anyone is curious). The macros I've written for it show/hide certain columns (real answer and the score for each question), apply simple formulas to the area where I want statistics to be shown, and then clears all the data (but not the formulas) to start all over again.

All of this is well and good, but it only works with a fixed set of questions.

My idea was to create a repository of questions (one unit per sheet), from where an hypotetical macro would randomnly pick several (with their correct answers) and place them in the "test" sheet. In that case, please, disregard how the test sheet is currently organized, that can be sorted out later both in the sheet and in the macro code.

I have been searching in this forum and the Spanish one and I've come across solutions that "might" come close to what I want, but to no avail, and my question, before I start fooling around with code (I'm no programmer), is: is this possible in LibreOffice?

[MrProgrammer]

Hi, and welcome to the forum.

… where an hypotetical macro would randomnly pick several (with their correct answers) …

Perhaps you don't need a macro: [Tutorial] Randomization in Calc

I'm no programmer.

Only programmers can write macros.

If this solved your problem please go to your first post use the Edit ☐ button and add [Solved] to the start of the Subject field. Select the green checkmark icon at the same time.

[Tutorial] Ten concepts that every Calc user should know

[DocenteEstresada]

Thank you. I already checked that out a while ago. I'd very much prefer using straight out formulas in the spreadsheet, to be honest, but if I could be able to trigger the whole process at the click of a button.

The point is to have the repositories hidden and under a password, so the pupil would olny see the "test" sheet at all times. At a click from a button, the random questions would appear. I know it can be done in Excel because one of my teachers at Uni used thise method, but I have no idea if this can be translated into LibreOffice, which is what we use at our working place. I will let this sit a few more days, if it's not much of a nuissance, to see what other people might have to say about this.

[Villeroy]

A database of multiple choice tests:

[DocenteEstresada]

I... wow...

Yes, that's why I hit a wall so many times. I just needed to think outside the box! Thank you very much, everyone!