The AVERAGE, MIN, MAX, COUNT Functions
  1. Locate cell A16. Type "Lesson 2" . Bold this cell.
  2. Locate cell A17. Type "Avg. Share Price"
  3. Locate cell B17. Type the formula: =average(C3:C12)
  4. Locate cell A18. Type "Highest No. of Shares"
  5. Locate cell B18. Type =max(D3:D12)
  6. Locate cell C18. Type the symbol of the company that corresponds to your findings in the previous question (if there is more than 1, type all of them).
  7. Locate cell A19. Type "Lowest No. of Shares"
  8. Locate cell B19. Type =min(D3:D12)
  9. Locate cell C19. Type the symbol of the company that corresponds to your findings in the previous question (if there is more than 1, type all of them).
  10. Locate cell A20. Type "No. of Companies in Portfolio"
  11. Locate cell B20. Type =count(D3:D12)


If you have data in L, M, and N, Go on to the NEXT LESSON
Hosted by www.Geocities.ws

1