Question: Design a professionally formatted worksheet that will be used to display the individual park visitor data (this worksheet will be copied in later steps). Include

Design a professionally formatted worksheet that will be used to display the individual park visitor data (this worksheet will be copied in later steps). Include an area to enter the name of the individual park and the park visitor categories listed in the table below. Name the worksheet Park Data. Create four copies of the Park Data worksheet, one for each of the national parks listed in Table 4. Be sure to rename each worksheet! Enter the data from Table 4 below into the correct park worksheet. Insert a picture of the park and place it appropriately on the worksheet. Table 4: 2021 National Park Visitors Acadia NP Death Valley NP Gettysburg NMP Grand Canyon NP Katahdin Woods and Waters NM Recreation Visits 3,994,374 1,082,328 680,820 4,417,541 39,558 Non-recreation Visits 47,100 43,694 74,400 20,667 2,187 Concessioner Lodging Overnights 0 9,091 0 354,887 0 Concessioner Camping Overnights 1,383 1,991 0 41,764 0 Tent Overnights 100,156 80,454 0 105,647 851 Recreation Vehicle Overnights 37,366 83,337 0 48,286 0 Backcountry Overnights 1,471 4,051 0 326,403 183 Misc. Overnights 0 0 0 6,119 0 Rename the Park Data worksheet to Summary Park Data. Change the Park Name text so that it is appropriate for the Summary sheet. In the Summary Park Data sheet, create 3D formulas for each category that add up the visitors in the four park sheets

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!