$12.$ Bao has a text file that describes the types of media the company provides. Import the text file as follows:

a$.$ Get data from the Text$/$CSV file Support$\_$EX$365\_2021\_$CS$4-7$a$\_$Media.txt$.$

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. $[$MAC Hint: Use Text Import Wizard to import data as tab delimited text.$]$

d$.$ View the imported data as a table and insert the data in cell H$5$ of the existing worksheet. $[$MAC Hint: Import data as text and update the table name from "Table$\_2"$ to "Support$\_$EX$365\_2021\_$CS$4\_7$a$\_$Media".$]$

e$.$ Apply Blue, Table Style Medium $2$ to the imported table to coordinate with the rest of the worksheet contents. $[$MAC Hint: Format as Table using Blue, Table Style Medium $2.]$

$13.$ Bao decides that he might want to sort and filter the revenue data. Format the range A$5$:F$12$ as a table with headers.