Go to the Stores worksheet. Jacob wants to display information about lighting products purchased according to store and manufacturer. He has received this data in a text file. Import the data as follows:

Import data from the Support_EX19_10a_Mac_LD.txt file to a new worksheet in the NP_EX19_10a_Mac_FirstLastName_2.xlsx workbook.

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

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

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 Green, Table Style Medium 7.)

Go back to the Stores worksheet. Jacob wants to show the categories of products sold in each of the company's five stores during 2021

In cell A2 of the Stores worksheet, insert a PivotTable based on the data in the Products table.