do a scored survey

I have long excel sheet, I want to create something like an application that goes through each row and create a question that is read from one row and show the other options. based on the answer of the user, it is scores number in the cell in its related row and column, afterwards create a final some after the survey/ quiz finish A