Question: 1. You're given the Excel spreadsheet below: Notice that this table has six fields: Order ID, Product, Category, Amount, Date, and Country. You are asked
1. You're given the Excel spreadsheet below: Notice that this table has six fields: Order ID, Product, Category, Amount, Date, and Country. You are asked to create a PivotTable that displays the amount of fruits and vegetables for each country You should be able to filter the data such that only fruits or vegetables appear in the PivotTable. Your PivotTable will look like the image below. a. Which field(s) should be placed in the Rows area of the PivotTable? (2.5 Points) b. Which field(s) should be placed in the Columns area of the PivotTable? (2.5 Points) c. Which fields) should be placed in the Values area of the PivotTable? (2.5 Points) d. Which field(s) should be placed in the Filters area of the PivotTable? (2.5 Points)
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
