need help with $33-38.$ Create the following relationships.

Relationship $1$

Table Name

Inventory

Column $($Foreign$)$

Warehouse

Table

Warehouse

Column $($Primary$)$

Warehouse

Relationship $2$

Table

Orders

Column $($Foreign$)$

Item$\_$Number

Table

Inventory

Column $($Primary$)$

Item$\_$Number

Use PowerPivot to create a blank PivotTable on a new worksheet. Add the following fields to the PivotTable.

Rows

Warehouse: Location

Warehouse: Warehouse

Inventory: Item$\_$Number

Values

Inventory: Current$\_$Inventory

Inventory: Total$\_$Value

Insert a Slicer based on Warehouse. Place the upper left corner of the Slicer inside the borders of cell F$3.$

Create a $3$D PowerMap that displays the location of all warehouses based on the City geographic type. Rename the worksheet containing the PivotTable and slicer as Inventory.

Make the Orders worksheet active. Use the Data Analysis ToolPak to output Summary statistics starting in cell G$3.$ The statistics should be based on the quantity of orders located in the range E$1$:E$56.$ Be sure to include column headings in the output.

Record a macro using the Macro Recorder named Sort. When activated, the macro should sort the Orders table in ascending order by date. Open the newly created module in the Visual Basic Editor and copy the code in Module$1.$ Paste the code starting in cell A$1$ on the Code worksheet.