Excel and MS Word as Learning Aids NK

Excell-At Overview

I will describe Excell-At using Microsoft Excel as an example, but the method can be used with other spreadsheets.

Excell-At uses two tricks:

  1. 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.

  2.  The formula =Rand() generates random numbers.
    If you have a column of random numbers in a table, then sorting the table on that column shuffles all the rows.

A minimum 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


  1. Select the answers and change their font color to white.


  2. Type =Rand() in cell A2 and drag it to the bottom row of the table.
  3. Look at a question, think about the answer, then click in the answer cell and check the answer in the formula bar.
  4. Repeat (3) with the other rows.
  5. To shuffle the rows
    Click in a cell in column A, then click on one of the sort buttons on the standard toolbar.


A useful Excell-At application will contain master-sheets, and quiz sheets and will probably also have many more columns.


Excell-At in Real Life discusses practical ways of using the technique.


Excell-At Examples contains applications which you can download and store on your own computer.


Excell-At for Beginners give detailed instructions for those people who donít understand these instructions or who are not experienced at sorting in Excel.


Excell-At Overview
Setting up Excell-At
Excell-At in Real Life
Excell-At Examples
Excell-At For-Beginners
Which-Word Overview
Which-Word - Details
Which-Word Summary
Word Techniques
Which-Word Resources

Hit Counter      Home Excell-At Which-Word Odds-And-Ends Contact