Tech Tool: Spreadsheet Software Software Videos: Spreadsheet Data Tables, Spreadsheet PivotTables and PivotCharts Now that you have
Question:
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.
Download the spreadsheet data file for this exercise.
Create a PivotTable to analyze the data.
Create a line chart to contrast the stock performance of the three companies.
Develop a digital dashboard that can be used to monitor stock performance.
The data file contains weekly stock price for GE, IBM, and Expedia for year 2010.
Fantastic news! We've Found the answer you've been seeking!
Step by Step Answer:
Related Book For
Accounting Information Systems The Crossroads of Accounting & IT
ISBN: 978-0132991322
2nd Edition
Authors: Donna Kay, Ali Ovlia
Question Posted: