computer applications and business systems - Travel Data Calculations and Pivot Table

profilefeoeigw2g3
mod_5_data_file.xlsx

Sheet1

Your Name
Your Travel Destination Cost of Trip: 3500
Contact Name Number of Travelers Insurance Cost Total Down Payment Amount Due
3 250 8,000
2 - 0 6,500
2 250 6,400
1 - 0 1,000
1 250 1,500
4 - 0 12,000
Total: Number of travelers times the cost of the trip plus insurance. (remember absolute and relative)
Amount Due: Total minus Down Payment
Helpful and Important Hints:
Remember absolute and relative when calculating the Total.
The formula in the total should work without you changing anything if someone calls in and adds insurance.
The formula in the total should also work without you changing anything in case the trip cost changes

Sheet3