Answer:
Attached is the excel solution
answer : The percentage of the barrier island that is bare earth = 46.88
Step-by-step explanation:
ROUND((B5*100/SUM(B2:B5),2) is used to calculate the percent of barrier island that is bare earth.
SUM(B2:B5) is used to compute the total area of barrier island.
while B5 stores the area of Bare Earth.