On 21/01/2014 21:01, (.:.) wrote:
I'm Italian and I'm trying to learn English language as better as
possible in order to try to pass an FCE exam next 10th June.
For a better memory training I thought that:
I would do a lot of "repetitions".
I try to explain better (and I'm super super super rossy for my really
poor English (in fact, I'm studying it)).
Using an Excel spreadsheet like that previously prepared by me:

A B
1 | adesso | now |
2 | even if | anche se |
3 | instead | invece |
4 | indeed | infatti |
5 | brush up | rinfrescare |
6 | etc. | etc. |
7 | . | . |
8 | . | . |
9 | | |

the "software" or the "macro", random should give me a question taken
by, for example, what's found in Row 3-Coulmn A (instead) than wait for
my answer (invece) that's what is written in the same row but in Column B.
Considering the fact that as a programmer I'm "below zero", it's
complicate to realize something like that?
Does already exist something that should do what I need so I can use it
immediatly without spend my few time in programming and using it for
study English?
Thanks!

How about something simple and all in the spreadsheet?

Set
E2 =INT(RAND()*COUNTA(A:A)+1)
E3 =INDEX(A:A,$E$2,1)
F3 =INDEX(B:B,$E$2,1)
Conditional format G3 green if G3 = F3

Calculation mode to manual. Give it a quick test then hide column F.
Or set the text colour in F3 to white(then select to see right answer)

Pressing F9 will give you a new random test.

--
Regards,
Martin Brown