please complete this excel assignment and post the results with the steps you took to acheive those steps

A MULTIPLE SHEET TEMPLATE FOR NATIONAL PARKS DATA Data files nesec You are working in the National Headquarters of the National Parks Department. One of your jobs this week is to develop a template for individual park use data, along with a Summary of the porks visitation data. To do this you will need to create a template with summary and individual park sheets, and then use the template to eater park data for five national parks. 1. Open a blank spreadsheet. 2. Design a professional quality shect to display individual park data. Include areas to enter the name of a park and the park statistics college in Table 4 below. Name the sheet Park Data. (Do not copy the physical layout of Table 4.) Figere 6.17 below is an exanyple of how you could set this up: National Parks 2015 Data Park Name: Recreation Visitors Non-Mecreation Visitors Recreation Hours Non-hecreation Hours Concessioner todging Concessioner Camping Tent Campers RV campers Backcountry campers Miscellaneous Overnight stays Figure 6.17 Sample setup 3. Make a copy of the Park Data shect and rename it Summary Park Data Change any text beeded for the Suemmary sheet. Make sure both sheets are laid out exactly the same 4. Save the file as a template called SC6 National Parks Tenplate.xltx. Make sure this gets saved to your USB and not the default folder on your hard drivel Close the template once it bas been saved. tecinning txCtL ars 5. Make a new file using the template and save it as SC6 Five National Parks.xlsx. 6. Make four copies of the Park. Data sheet. Rename the five Park Data sheets after the five parks listed in Table 4. Table 4: 2015 National Park Data Figure 6.17 Smple setup 3. Make a copy of the Park Data sheet and remame it Summary Park Data. Change any text needed for the Summary sheet. Make sare both sheets are laid out exactly the same. 4. Save the file as a template called SC6 National Parks Template.xltx. Make sure this gets saved to your USB and not the default folder on your hard drivel Close the template once it has been saved. Btcinsithe rexti ste 5. Make a new file using the template and save it as SC6 Five National Parks.xlsx. 6. Make four copies of the Park Data sheet. Rename the five Park Data sheets after the five parks listed in Table 4. Table i: 2015 National Park Data 1. Enter the park data for each of the parks in each of the five sheets. 2. In the Summary Park Data sheet, create formulas for all the fields that add up the five park sheets. 3. Preview the entire workbook in Print Preview to ensure that it is printing protessionally. Make any changes needed. 4. Save the SC6 Five National Parks warkbook. 5. Submit both the SC6 Five National Parks and SC6 National Parks Template files as directed by your instructor. National Park 2015 Data from: https//irma nps gow/Stats/SSRSReports ATTRIBUTION "6.6 Scored Assessment" by Diane Shingledecker, Portland Community College is licensed under CC BY 4.0