Plz solve problem below thank you. Show formula sheet plz. i need the formula sheet shown on excel with the answers

This question is to be completed in Excel. Upload your worked excel files as deliverable for this Question]. The data on the percentage of visitors in the previous and current years at 12 well-known national parks of the United States are given below

National Parks	Percentage of visitors previous year	Percentage of visitors current year
The Smokies	78.2%	84.2%
The Grand Canyon	86.4%	88.6%
Theodore Roosevelt	81.6%	84.8%
Yosemite	74.2%	78.4%
Yellowstone	77.9%	76.2%
Olympic	86.4%	88.6%
The Colorado Rockies	84.3%	85.4%
Zion	76.7%	78.9%
The Grand Tetons	84.6%	87.8%
Cuyahoga Valley	85.1%	86.7%
Acadia	79.2%	82.6%
Shenandoah	72.9%	79.2%

a. Sort the parks in descending order by their current years visitor percentage. Which park has the highest number of visitors in the current year? (2 points)

b. Which park has the lowest number of visitors in the current year? (2 points)

c. Calculate the change in visitor percentage from the previous to the current year for each park. (2 points)

d. Use Excels conditional formatting to highlight the parks whose visitor percentage decreased from the previous year to the current year (2 points)

e. Use Excels conditional formatting tool to create data bars for the change in visitor percentage from the previous year to the current year for each park calculated in part c