This project will be simple, but once you learn the concept you can create bigger files and databases. For this project we will have a text file with three variables, WORD, ANSWER, and WRONG. This will be for my quiz program that displays the word and gives two options where students select the correct answer. At the end I will show some other shortcuts that can be added to save even more time.

 

First you need to open your spreadsheet.

 

In column A, row 1 type the following:

 

&word1=

 

Now skip over to column C row 1 (from here called C1 etc) and type:

 

&answer1=

 

Now skip over to column E1 and type:

 

&wrong=

 

To clarify, all you are doing is clicking once on the cell and then you start typing. At this point you should have this:



Now you want to click and drag from A1 to E1. They should all be highlight as shown below.