Setting up an Excell-At Application
A practical Excell-At Application will have at least 5 worksheets:-
You may want to have more than one Master worksheet. For example if you are learning a foreign language the nouns might have a gender and vary according to whether they are the subject of object of a sentence, or singular or plural. The verbs might vary significantly according to their tense or the subject of the verb. It might be convenient to keep each kind of word in its own Master table.
You will almost certainly generate several Quizzes from each Master. Each Quiz can be stored in its own worksheet. Alternatively you can store several Quizzes in a single worksheet, as long as each quiz is isolated by at least one empty row and column.
Setting Up a Quiz
I will use an example with the dates of classical composers.
Apart from the Select column, the Master, Master Backup and Working Master worksheets are identical.
Select rows by putting a character in the Select cells, click in a cell in the Select column and click on the Sort Descending button.
The selected rows rise to the top of the Working Master sheet from where they can be copied and pasted into a Quiz worksheet.
In the Quiz Worksheet delete unwanted columns, add a Shuffle column, and type the formula =rand() in the top shuffle cell. Select this cell, click on the small square in the bottom right corner of the cell and, when the mouse pointer changes to a black +, drag the formula to the last row.
It is now time to decide which column(s) will be the "answers". I will assume that you want to learn the years in which the composers died. I show you elsewhere how to keep the possible answers on display while you are using a Quiz
Now select all the answers in the main table and change their font colour to match the background. The answers effectively disappear.
This is a good time to copy the Quiz worksheet to create the Quiz Backup worksheet.
To use the Quiz, think of an answer and then click in the concealed answer cell. The answer will appear in in the formula bar. When you think you know the answer you may like to change the font colour back to automatic. You can then concentrate on learning the items which you don't already know.
To shuffle the rows, click on any cell in the Shuffle column and then click on one of the Sort Buttons in the Standard Toolbar.
In Excell-At in Real Life - Adding sound, and other techniques I discuss using sound files both as questions and as answers.
Techniques and tips are also discussed in Excell-At Examples.
In Excell-At for Beginners I discuss in detail the computer techniques used in creating and using Excell-At applications. Unless you fully understand sorting it is worth looking at Sorting in Excell-At for Beginners.