Help ASAP
o continue our travel project theme, we will first complete our data and then create a Pivot Table to provide us with the travelers that have a balance due greater than or equal to $2000.
Open the Module 5 Data file linked below and follow these steps (click the Enable Editing button, if necessary):
- Add your name and your travel destination.
- Add first and last names for all travelers.
- Create formulas for the Total and Amount Due columns. (The information is given on the sheet).
- Create a pivot table for the information. Use the travelers, totals, and amount due fields.
- Filter the pivot table to show only those travelers with a balance of 2000 or more. HINT: you should have four (4) travelers after you filter.
- Save the Excel document using the naming convention given at the end of this assignment.
9 years ago
13
Answer(1)![blurred-text]()
![]()
Purchase the answer to view it

NOT RATED
- mod_5_data_file.xlsx
Bids(1)
other Questions(10)
- Read about the Aryans and their migration into the Indus Valley in the Hinduism Chapter in your textbook (Huston Smith
- A manufacturer produces 1000 computer chips for a mission-critical application. Each chip costs $100 to manufacture and sells for $2000, but...
- Due today by midnight
- management assignment
- COMPUTER TECH BIS220
- Help with homework
- 250 Word Essay Due (10:30pm EST 9/14/14)
- ECO 550 Assignment 3 Market Model Patterns of Change
- Economics -3
- BUS 660 Week 1 Assignment Leadership Competency Models