Step 4: Another formula you can use to calculate percentage is simply applying the / key in between two cells. For example, to pass a driving theory test, I need to get 80% of the questions correct.