Create a chart as follows to illustrate this information:

a$.$ Use the Quick Analysis tool to create a Stacked Column chart that compares the revenue from each type of media for Quarters $14($range A$5$:E$11).[$MAC HINT: Select Stacked Column chart from Recommended Charts under the Insert tab.$]$

b$.$ Switch the rows and columns to compare the four quarters of data rather than the six types of media.

c$.$ Move and resize the chart so that the upper$-$left corner is in cell F$15$ and the lower$-$right corner is in cell K$37.$

$11.$ Bao decides he wants the chart to compare revenue from movies only. Modify the Stacked Column chart as follows to meet his request and make the chart more meaningful:

a$.$ Remove the TV Shows data series from the chart.

b$.$ Add a Data Table with legend keys to the chart.

c$.$ Use Movie Revenue as the chart title.

d$.$ Remove the legend, which repeats information in the data table.

$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.