7.38 Tech Tool: Spreadsheet Software Software Videos: Spreadsheet Data Tables, Spreadsheet PivotTables and PivotCharts Now that you have a full-time position, you have decided to start investing. You have invested in three different companies. You are using a spreadsheet to track stock prices for the three different companies for a 12-month period.

1. Download the spreadsheet data file for this exercise.

2. Create a PivotTable to analyze the data.

3. Create a line chart to contrast the stock performance of the three companies.

4. Develop a digital dashboard that can be used to monitor stock performance.