Excel:Wrapping up the Spreadsheet.
Be sure to format all columns for appropriately (currency or percentage).
Part 1: Last Check
  1. Label AA2 "Share Price"
  2. Enter your share prices from CNN/Money in cell AA3:AA12 as you normally would.
  3. Enter the date in AB1
  4. Label AB2 "Sold"
  5. From AB3:AB12, mulitply Share Price in AA3 and Number of Shares in E3 as you normally would
  6. Type "Overall Total" in AA13.
  7. Find the sum of AB3:AB12 in cell AB13, as you normally would.
  8. Label AC2 "Overall Percent Change"
  9. Calculate percent change in AC3:AC13, as you normally would.
  10. Label AD2 "Share Price Increase".
  11. In AD3:AD12, enter the formula =AA3-D3 to show the increase or decrease in the price of a single stock.
  12. Type "Overall Earnings" in AD13. Bold this cell.
  13. Label AE2 "Earnings/Loss"
  14. Enter the formula in AE3 that will find the difference between "Investment" and "Sold" (big hint: 1. difference usually means subtraction. 2. Look at W3).
Part 2: Summary
  1. Go to cell AA16. Type "Lesson 8: Summary". Bold this cell.
  2. Go to cell AA17. Type "Most Profit"
  3. Go to cell AB17. Using the MAX function, calculate the company with the most profit from AE3:AE12.
  4. Type the name of company that earned you the most money in AC17.
  5. Go to cell AA18. Type "Least Profit"
  6. Go to cell AB18. Using the MIN function, calculate the company that earned the least profit from AE3:AE12.
  7. Type the name of the company that earned you the least profit in AC18.
  8. In AA19 type "Highest Share Price Increase".
  9. In AB19 enter a formula that will tell you which company had the highest Share Price Increase from column AD.
  10. AC19 type the name of this company.
  11. In AA20 type "Lowest Share Price Increase".
  12. In AB20 enter a formula that will tell you which company had the lowest Share Price Increase from column AD.
  13. AC20 type the name of this company.
  14. Go to cell AA21. Type "Highest Percent Increase".
  15. Using the MAX function, calulate the company with the highest Overall Percentage Change in AB21.
  16. Type the name of this company in AC21.
  17. Go to cell AA22. Type "Lowest Percent Increase".
  18. Using the MIN function calulate the company with the lowest Ending percentage increase in AB22.
  19. Type the name of this company in AC22.
Part 3: Take a deep breath.
  1. Go to cell AA23. Type "Overall Total". Bold this cell.
  2. Go to cell AB23. Enter the "Overall Total" that you ended up with (look in column AB).
  3. Go to cell AA24. Type "Ending Percent Change".Bold this cell.
  4. Go to cell AB24. Enter the Overall Percent Change that you ended up with (look in AC13).
  5. Go to cell AA25. Type "Overall Profit". Bold this cell.
  6. Go to cell AB25. Enter the Overall Profit that you ended up with (look in column AE).
Hosted by www.Geocities.ws

1