To continue our travel project theme, we will first complete our data and then create a Pivot Table t

Question # 00765682 Posted By: shortone Updated on: 06/18/2020 08:31 AM Due on: 06/30/2020
Subject Computer Science Topic Algorithms Tutorials:
Question
Dot Image

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. 

 

  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.
Dot Image
rasmussen
Tutorials for this Question
  1. Tutorial # 00766306 Posted By: shortone Posted on: 06/18/2020 08:32 AM
    Puchased By: 2
    Tutorial Preview
    The solution of To continue our travel project theme, we will first complete our data and then create a Pivot Table t...
    Attachments
    Solution-00766306.zip (96 KB)

Great! We have found the solution of this question!

Whatsapp Lisa