50.1K

Verified Solution

Link Copied!

1. Open the data file PR5 Data from the Data Files and save the file to your computer as PR5 Canyon Trails.
2. In Column J, calculate Total Cost (Number of Guests *Per Person Cost). Copy the formula down the column.
3. Format Columns I and J with Currency and no decimal places.
4. Center all headings in Row 3.
5. Click in cell A3. Insert a table with headers for the range A3:J53.
6. Adjust column widths within the table so that all the headings are completely visible.
7. Rename Sheet 1 Current Tours. Sort this sheet alphabetically (A to Z) by Last Name.
8. Make a copy of the Current Tours sheet and rename it Tours by Canyon. Place the Tours by Canyon sheet to the right of the Current Tours sheet. Sort this sheet by Tour Canyon (A to Z), then Home Country (A to Z), and then Last Name (A to Z).
9. Make another copy of the Current Tours sheet and rename it US Guests. Place the US Guests sheet to the right of the Tours by Canyon sheet. Filter this sheet so that only guests with a Home Country of the United States show. Sort the filtered data alphabetically (A to Z) by Tour State. Add a Total Row that sums the Guests and Total Cost columns.
10. Make one more copy of the Current Tours sheet and rename it Tours by State. Subtotal the sheet by State, summing the Total Cost column.
11. Need questions 8-10 answered

Answer & Explanation Solved by verified expert

See Answer