Module 5 Travel Data Calculations and Pivot Table Assignment

Our academic writers are ready and waiting to assist with any assignment you may have. From simple essays to full dissertations, you're guaranteed we've got a writing expert to perfectly match your needs.


Order a Similar Paper Order a Different Paper

To 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):

Module 5 Data File ( attach below)

  1. Add your name and your travel destination.
  2. Add first and last names for all travelers.
  3. Create formulas for the Total and Amount Due columns. (The information is given on the sheet).
  4. Create a pivot table for the information. Use the travelers, totals, and amount due fields.
  5. 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.
  6. Save the Excel document using the naming convention given at the end of this assignment.
Writerbay.net

Do you need help with this or a different assignment? In a world where academic success does not come without efforts, we do our best to provide the most proficient and capable essay writing service. After all, impressing professors shouldn’t be hard, we make that possible. If you decide to make your order on our website, you will get 15 % off your first order. You only need to indicate the discount code GET15.


Order a Similar Paper Order a Different Paper