You may use this to analyze any type of test you'd prefer. I use this format to assess my benchmark tests which our students take three times a week. Please see the comments in the Excel spreadsheet for information on how to edit / add and change certain elements.
See images to get an idea of how this can be used.
This spreadsheet can be used to keep track of correct and incorrect answer choices given, the number of correct and incorrect answers provided for a particular question, and the final score for each student as well on the given assessment.