Currently, I have a cell that randomly chooses the words from 25 cells above. However, the only way to have it choose randomly again is for you to refresh the spreadsheet, which is definitely not what I want. (Picture below.)
enter image description here
I then need a cell to the right of it to be where you type the answer. Depending on whether you’re right or not, it will show whether you are right or not. If you are correct, it will move on to the next word. If you are wrong, it will say incorrect and show you the correct answer, then move on to the next word. Currently, I am lost, so I would be very helpful if I could recieve all the code to do it.
I don’t really know how to code on spreadsheets at all… so… and I’m way to lazy to actually spend time and learn.
Kaiyan Wang is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.