Instructions

Open a blank Excel workbook. Save the file as SC$6$ National Parks.

Starting in cell A$2,$ create a table with the categories $$Type of Visit$$ and $$Number of Visits.$$ Include the park visitor categories listed in Table $4.$ Format your table as Blue, Medium Style $13.$ Name the worksheet Park Data.

On the line above your table, merge and center A$1$ and B$1.$ Format the merged cell as $20\%$ Accent $5.$ This will be where you include the name of the park. Add placeholder text in this merged cell area: $$Name of Park$$

Format the title as Bold, Century font size $14.$ Format the table column titles as Century font size $12.$ Change the width of the $$Number of Visits$$ column to $19(119$ px$).$ Format the table data as Century font size $11.$

Create four copies of the Park Data worksheet, one for each of the national parks listed in Table $4($you should have five worksheets in total$).$ Rename each of the four worksheet copies to the park name $($for example Blue Ridge Pkwy$)$

Format each of the five worksheet tabs with a different color $($your choice$).$

Enter the data from Table $4$ below into the correct park worksheet. $($Be sure to update the placeholder text to the park name in the merged cells above the table.$)$

In all worksheets, format the data as numbers, include a comma, no decimals.

On EACH worksheet, Insert the URL to the park website and place it below the table in Cell B$12.$

Insert a comment for the Blue Ridge Parkway cell with the highest number of recreation visits. In your comment, state $$highest number of recreation visits.$$

Table $4-$ National Park Visitors

Type of Visit

Blue Ridge Pkwy

Crater Lake NP

Yellowstone NP

Yosemite NP

Recreation Visits

$14,862,422$

$696,337$

$4,104,444$

$3,896,657$

Non$-$recreation Visits

$1,942,260$

$49,600$

$1,223,591$

$144,420$

Concessioner Lodging Overnights

$46,001$

$34,614$

$663,150$

$660,362$

Concessioner Camping Overnights

$0$

$42,039$

$616,194$

$0$

Tent Overnights

$59,056$

$6,814$

$88,304$

$378,201$

Recreation Vehicle Overnights

$34,158$

$0$

$73,872$

$270,740$

Backcountry Overnights

$787$

$2,641$

$42,215$

$124,725$

Misc. Overnights

$1,294$

$0$

$11,834$

$18,345$