computer applications and business systems - Integrating the Pivot Table into a Word Memo

profilefeoeigw2g3
mod_5_data_file_4.xlsx
Home>Business & Finance homework help>Management homework help>computer applications and business systems - Integrating the Pivot Table into a Word Memo

Sheet8

Row Labels Sum of Amount Due Sum of Number of Travelers Sum of Insurance Cost Sum of Total Sum of Down Payment
Elenor Pollack 850 2 250 7250 6400
Jeremy shummers 2250 1 250 3750 1500
Jeremy Winters 2750 3 250 10750 8000
kenneth Springer 2500 1 0 3500 1000
Marlene Smith 2000 4 0 14000 12000
Marlene Winters 500 2 0 7000 6500
Grand Total 10850 13 750 46250 35400

Sheet1

Your Name
Blue Mountains Cost of Trip: 3500
Contact Name Number of Travelers Insurance Cost Total Down Payment Amount Due
Jeremy Winters 3 250 10,750 8,000 2,750
Marlene Winters 2 - 0 7,000 6,500 500
Elenor Pollack 2 250 7,250 6,400 850
kenneth Springer 1 - 0 3,500 1,000 2,500
Jeremy shummers 1 250 3,750 1,500 2,250
Marlene Smith 4 - 0 14,000 12,000 2,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