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%.”