You can already see how easy and useful this can be. But it’s still not over, there are other things we can do that save even more time. Plus we have to concatenate them all together to make the file.

 

Now, to make use of the spreadsheet we need to group similar answers together. I am going to make this about “is it a verb or an adjective?” So the word will be either a verb or an adjective. I’ll have the first 10 as verbs and the last 10 as adjectives. I have to type in each one of these, but it won’t take that long.



Now back to the beauty of the spreadsheet

 

Type in the answer once in D1, and the wrong answer in F1. Then click our magic box and drag them down to row 10. Do this once each for both columns. You could also click drag all the boxes and hit CTRL-D which fills the rows down with whatever is in the top box. CTRL-D doesn’t increment, it simply copies. If there is nothing to increment, the little magic box will just copy also.