Excel Exercise - Assignment 4

views comments

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

Tags