PART-B Instructions: Visual stock data summary

1. Create a new worksheet named All Closing. Copy the daily closing prices of the 5 stocks in your portfolio, for the duration you held the stocks.

2. Also copy the closing value of the NASDAQ divided by 100 to get the "price" of the index for the same time period.

The All Closing worksheet would look like following:

Date Stock1 Stock2 Stock3 Stock4 Stock5 NASDAQ

10/13/20 17 $ xxx $ xxx $ xxx $ xxx $ xxx $ xxx

10/8/201 8 $ xxx $ xxx $ xxx $ xxx $ xxx $ xxx 3.

Create a pivot table and pivot chart in a new worksheet that shows the monthly average closing prices for all the five stocks and NASDAQ

4. Make sure that the chart has a title, the appropriate legends, and is properly formatted.

a. Make sure lines are clearly visible (increase the thickness of the lines if needed) and b. Use the secondary axis to plot the data (if needed).