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

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

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!