Foresthillshs.enschool.org



Stock Club Lesson Part 2RosnerCompare your stock portfolio to this one. Are your averages different? I bet you accidentally averaged the totals into your average cells. Go back to the average results and change the formula so that it ends at row 8 for each column to correct this problem.Notice anything else different? If so, let’s find out why…call me over, help a neighbor, ask a neighbor.Let’s insert 2 rows after your last stock so that cells 9 and 10 can hold 2 new stocks.Use this link to look-up the symbols for two stocks of your choice: this next link to look-up the price of these two stocks from ONE YEAR AGO and from today to fill in the necessary data for your chart.**Use the CLOSING price.***If nothing is showing up, you might have typed in the date of a weekend or holiday when the stocks are still sleeping! Insert the new data in your stock portfolio chart. And Color their Background in a color of your choice.OH NO! You will have to fix the formulas for your totals and averages again to include the new cells.Add “all borders” to your work.Bonus Extension:Feeling fancy? Change your font sizes and styles.Add colors to differentiate each row from one another for easy reading.Increase the size of titles for columns and rows and center each one within its cell. ................
................

In order to avoid copyright disputes, this page is only a partial summary.

Google Online Preview   Download