Question: PLEASE HELP! I am lost and do not know what to do! Thank you. 3. Go to the Material worksheet. Lucia wants to display information

PLEASE HELP! I am lost and do not know what to do! Thank you.
3. Go to the Material worksheet. Lucia wants to display information about products sold according to location and material. She has been tracking this data in an Access database. Import the data from the Access database as follows: a. Create a new query that imports data from the Support_EX19_10b_Restore.accdb database. Select the 2021_Orders, Products, and Sales tables for the import. Only create a connection to the data and add the data to the Data Model. b. C. On the Material worksheet, Lucia wants to show the material of the products sold in each of the company's five locations during 2021. d. In cell B2 of the Material worksheet, use Power Pivot to insert a PivotTable based on the data in the 2021_Orders table. Edit the PivotTable as follows to provide this information for Lucia: Use the following fields from the 2021_Orders table in the PivotTable: Material field for the row headings SiteCity field for the column headings ItemQty field for the values 4. b. Use Products Sold as the custom name of the Sum of ItemQty field. In cell B3, use Product Material to replace "Row Labels", and then resize column B to its best fit. C. d. In cell C2, use Locations to replace "Column Labels". Lia 3. Go to the Material worksheet. Lucia wants to display information about products sold according to location and material. She has been tracking this data in an Access database. Import the data from the Access database as follows: a. Create a new query that imports data from the Support_EX19_10b_Restore.accdb database. Select the 2021_Orders, Products, and Sales tables for the import. Only create a connection to the data and add the data to the Data Model. b. C. On the Material worksheet, Lucia wants to show the material of the products sold in each of the company's five locations during 2021. d. In cell B2 of the Material worksheet, use Power Pivot to insert a PivotTable based on the data in the 2021_Orders table. Edit the PivotTable as follows to provide this information for Lucia: Use the following fields from the 2021_Orders table in the PivotTable: Material field for the row headings SiteCity field for the column headings ItemQty field for the values 4. b. Use Products Sold as the custom name of the Sum of ItemQty field. In cell B3, use Product Material to replace "Row Labels", and then resize column B to its best fit. C. d. In cell C2, use Locations to replace "Column Labels". Lia
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
