Illustrated Excel $2019|$ Module $7$: SAM Project $1$a

$10.$ Ravi has the data comparing the revenues for the four companies stored in a text file. Import the text file as follows:

a$.$ Get data from the Text$/$CSV file Support$\_$EX$19\_7$a$\_$Combined.csv$.$

b$.$ Edit the text file before loading it to use the first row as headers.

c$.$ In the Power Query Editor window, choose to close and load to a location in the worksheet.

d$.$ View the imported data as a table and insert the data in cell A$27$ of the existing worksheet.

e$.$ Apply the Light Gray, Table Style Medium $22$ to the imported table to coordinate with the rest of the worksheet contents, and then format the range B$28$:H$31$ in the Accounting number format with no decimal places.

$11.$ Ravi originally inserted the $365$ Marketing revenue data as a link to another Excel workbook. He asks you to update the data and then remove the link.

Update and remove the link as follows:

a$.$ Display the links to external files, and then update the link to the workbook Support$\_$EX$19\_7$a$\_365.$xlsx$.$

b$.$ Break the link to the Support$\_$EX$19\_7$a$\_365.$xlsx file.

Your workbook should look like the Final Figures on the following pages. Close all support files. Save your changes, close the workbook, and then exit Excel. Follow the directions on the SAM website to submit your completed project.