The title itself says that analyzing the test results should be a very obvious thing right?
But that's where the problem starts for me.
After analyzing tons of questions i got wrong, how do i make sure i dont repeat the same mistakes again?
What is the best way to analyse a wrong answer and build on it for future ref?
Right now, i have been logging my errors in an XLS with the specific topic and subtopic written alongside them.
but i feel am not optimizing my analysis for future use

Pls could someone help me with the above?