Instructions

$1$ Go to the Streaming Subscribers worksheet.

Use the data to complete each of the following steps. Create a clustered column chart which displays the Year on the horizontal axis and the Netflix and Hulu subscribers as vertical columns within the same worksheet as the data. Name the chart "ColumnChart" using the namebox at the

$2$ top left of Excel.

$3$ Resize the chart so that the visualization can be clearly read.

$4$ Rename the chart as "Subscriber Comparison $($in millions$)".$

$5$ Insert data labels above each of the columns.

$6$ Change the colors of the Netflix bars to red and the Hulu bars to green $($or any two contrast colors

Create a line chart which displays the Year on the horizontal axis and the subscribers to Netflix an

$7$ Hulu as the individual lines. Name the chart "LineChart" using the namebox at the top left of Exce

$8$ Place the chart directly below the clustered column chart.

$9$ Resize the chart so that the visualization can be clearly read.

$10$ Rename the chart "Subscriber Growth Trends".

$11$ Change the color of the Netflix line to red and the Hulu line to green.

Using the Add Chart Element menu of the Chart Design Tab, add Up$/$Down Bars. Change the color

$12$ of the Up$/$Down Bars to light gray.

$13$ Save your worksheet

$14$ Go to the Fortune $1000$ worksheet.

$15$ Use the data to complete each of the following steps.

$16$ Format the values in Columns D and E as Currency.

In the Answers area, use the proper function to calculate the value in Column O based on each of the given criteria in Column N$.$ In Column P$,$ use the FORMULATEXT command to return what is

$17$ displayed in the formula bar of each cell in the Value column $($Column O$).$

$18$ Format any profit and revenue values as Currency. Auto$-$resize the columns as necessary.

$19$ Save your file as Excel Assignment $4($yourName$)$ Soln.xlsx