I will describe
Excell-At using Microsoft Excel as an
example, but the method can be used with other spreadsheets.
uses two tricks:
When a Font Colour and the cell
Highlight colour are the same colour, the data in the cell becomes
invisible. In Excel, when you click in such a cell the cell
contents appear in the formula bar.
The formula =Rand() generates
If you have a column of random numbers in a table, then sorting the
table on that column shuffles all the rows.
Excell-At application therefore consists of a table with a header
row, and 3 columns:
the random numbers, the questions,
and the answers.
This example has 2 answers for each
question so there is an extra column.
To use it
Select the answers and
their font color to white.
- Type =Rand() in cell A2 and
drag it to the bottom row of the table.
- Look at a question, think about
the answer, then click in the answer cell and check the answer in
the formula bar.
- Repeat (3) with the other rows.
- To shuffle the rows
Click in a cell in column A, then click on one of the
on the standard toolbar.
useful Excell-At application will
contain master-sheets, and quiz sheets and will probably also have many
in Real Life discusses practical ways of
using the technique.
Examples contains applications which you
can download and store on your own computer.
for Beginners give detailed instructions
for those people who donít understand
these instructions or who are not experienced at sorting in Excel.