Question: how to calculate percentage and grade in excel?
Answer: First, click into cell D2, so the percentage shows up in the Percentage column. Hit Enter to get the student's score as a percentage of the total possible points. You can then use the fill handle to drag the formula down to the rest of the scores. Multiplying by 100 shows you the percentage—not the decimal.