Answered step by step
Verified Expert Solution
Question
1 Approved Answer
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
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started