NOTE: If you are practicing questions using the online question banks provided by various course providers, this post might not be of much use. If you are using offline questions banks(as I did), then you might gain something from this post.
~~~~~~~~~~~~~~~~~
Hi Everyone,
While I was solving questions from offline question banks for Quant and Verbal, I faced this issue that I couldnt find out how much time I am taking, what kind of questions take more time, whats my accuracy etc etc. To get at least some idea, I started using excel sheet. In the beginning, it was simple, just questions and some kind of time taken for overall set of questions. But at every step I kept adding some new feature and although I am done with my GMAT, I wanted scoring sheet to be complete in all respects. The attached excel sheet is the product of the same.
Features -
- You can choose how many questions you want to do in that particular session.
- Just as in GMAT, you cannot skip a question, and once answered, you cant change the answer.
- It shows how much time you took for each question (fastest 5 and slowest 5 questions)
- You can input the answer key after taking the test and it can calculate your accuracy too.
Hope it is of some use. If you don't like, that's fine, you can provide some input and maybe I can try to improve it

One Tip: Follow the flow. Try not to move between tabs manually as it would simply ruin the experience.
Edit: One of the users in the forum highlighted a couple of glitches in the tool. question numbers were not reflecting properly and input screen was allowing to skip the question without an answer. Have fixed both the errors and uploading the new one here too. Scoring Sheet V1 is the revised one.Cheers!
AstroNut