When using Spreadsheets in Google Drive there is a wonderful tool called scripts that can really help the teacher. Spreadsheets may have been created directly or when we use a form as a way of assessing students or just to gather responses.
From the toolbar of the Spreadsheet, look for Tools.
You will see a few script related choices, and the best way to start is by looking at the Script gallery.
When Education is chosen, there are many scripts to choose from. There is one that comes with a Chinese title as you can see in the screenshot above. It is a simple and useful script for marking MCQ responses, and it does not matter that you cannot read Chinese. It is able to indicate which answers have been correctly answered, the scores for each student and also the score for each question.
Give scripts a try.