Class 33: Spreadsheet Stock Project II

Review Formatting/Stock I worksheet and cover sheet
Alt/enter, fractions, formulas, charts

Demo Stock II

Assign:

STOCK II COVER SHEET

NAME_____________________________________BLOCK_____

1. Find the current price for first 3 stocks and put in market price column
   
2. Add a new stock (#4–spend $1000 on new stock only)
   
3. Add a Gain/Loss column
4. Format correctly
5. Create a chart (NOT a pie chart)
   
6. Print and show me so I can check formulas
7. Hand in!

_____FORMATTED (5 POINTS EACH)

• NEW STOCK INFO
  
• BORDERS AND SHADING
  
• COLUMNHEADINGS CENTERED AND WORD WRAPPED
• CORRECT FORMATS: NUMBER/FRACTION/DECIMAL/CURRENCY

_____FORMULAS  (5 POINTS EACH)

• CURRENT VALUE, GAIN/LOSS, TOTALS
• GAIN/LOSS
  
• COLUMN TOTALS
  

_____CHART (5 POINTS EACH)

• NAME IN TITLE
• LEGEND WITH LABELS/TICKER AND CURRENT VALUE IN CHART
  
• TICKER SYMBOL AND INVESTMENT TOTAL IN CHART

_____TOTAL (50)

EXTRA:  (5 POINTS EACH)

• ABSOLUTE FORMULA FOR % OF TOTAL CURRENT VALUE
• SORT
• PICTURE OR TEXTURE FILL
• CLIPART IN TITLE
• MARKET PRICE FOR STOCK 4 AND COMMENT