Please answer correctly and asap. please do not copy and paste previous answers uploaded to chegg on this same question. since that is inorrect.

1. Jacob Sherman is the director of sales for Lighting Designs, a store and website that caters to building contractors in five locations in the Seattle area. Jacob asks for your help in producing a sales report. He wants to analyze sales for the past year and project future sales for all the stores. To create the report, you need to import data from various sources and use the Excel Power tools. Go to the Sales Summary worksheet, where Jacob wants to display a summary of the company's annual sales since the first store opened in the year 2000 . He has a text file that already contains this data. Use Power Query to create a query and load data from a CSV file into a new table as follows: a. Create a new query that imports data from the Support_EX19_10a_Summary.csv text file. b. Edit the query to remove the Units Sold and Notes columns. c. Close and load the query data to a table in cell A2 of the existing worksheet