Excel Exercise - Assignment 4
From Katherine Kendall
Assignment 4: Adding Data
Assignment Goal: This exercise should allow students to compile what they have learned so far in Microsoft Excel by adding additional data to their workbook.
Weekly Outcomes: At the completion of this week’s assignment, students will have an additional table of data for future charting.
Weekly Topics/Tasks: Adding Data
Retrieve market data from 2 years prior on Yahoo Finance for the assigned company
Copy and paste new data points into existing sheet with previous year's data
Create a new table to differentiate new data from existing data
Duplicate sum and average formulas created previously to apply to the new data