$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 as follows:

a$.$ Import data from the Support$\_$EX$365\_2021\_10$b$\_$Mac$\_$Restore.txt file to a new worksheet in the NP$\_$EX$365\_2021\_10$b$\_$Mac$\_$FirstLastName$\_2.$xlsx workbook.

b$.$ Start loading the data at row $1,$ and separate the columns using tab delimiters.

c$.$ Load the data to a new worksheet, using Product Data as the name of the new worksheet.

d$.$ Format the imported data as a table with headers using the Table Style Medium $7$ table style. $($Hint: If an alert comes up$,$ press "Yes" to convert the range to a table. Depending on your version of Office, the table style may be written as Teal, Table Style Medium $7.)$

e$.$ Rename the table using Products as the name.

Go back to the Material worksheet, Lucia wants to show the material of the products sold in each of the company's five locations during $2024.$

f$.$ In cell B$2$ of the Material worksheet, insert a PivotTable based on the data in the Products table.