Question: how to calculate a percentage in google sheets?
Answer: Enter the below formula to D2: =C2/B2.
Copy it down your table.
Go to Format > Number > Percent in Google Sheets menu to apply the percentage view.