How do I analyze this dataset?

Hi all

OK total newbie question here.  I've been getting some excellent help from this forum which is highly appreciated and hope someone can guide me through a way to analyze this.  So here is a data report in Excel I get from an external assessment moderator (I work in a primary/middle school).  It lists all the students down the left hand side along with the answer they got to each question (the questiosn are the weird codes found as column headers.  Now I want to analyze this.  Basically all Y answers are correct and the other letters are wrong, it basically tells us which answer other students gave so we can look into why that might be.  

I was hoping to put this into some kind of Graph but I can't get it to do anythign useful at all, what shoudl I do?