Question: how to calculate average percentage in google sheets?
Answer: Highlight the range B2:B5., In the bottom right, click Sum., Choose Avg., In the bottom right, you'll see “Avg: 87%.”