answer

QUESTION 2 (10 MARKS) The following questions are based on Figure B. Silver Dollars Stock Club Portfolio Summary - Microsoft Excel " Mont Inset Figtlyput Formulas Date Review I Autosum . AT A aCopy . DIFF pace . . " . Comation Fong Sort & Find a amazing" i Table. Whylies* Filter* Select D H Silver Dollars Stock Club Portfolio Summary Initial Current Percent Date Price Price Current Gain/ 3 Stock Symbol Acquired Shares Per Share Initial Cost Per Share Value Gain/ Loss LOSS 4 Apple Computer AAPL 12/1/04 440 5 64.590 $ 28,419.60 82.99 5 36,515.60 $ 8,096.00 28.49% 5 AT&T T 12/16/03 870 28.710 24.977.70 27.99 24,351.30 (626.40) -2.5 1% 6 Citigroup 1/17/03 960 49.460 47.481.60 44.675 42,888.00 (4,593.60) -9.67% Comcast CMCSA 12/11/02 380 33.620 12,775.60 41.39 15,728.20 2,952.60 23.1 16 8 Google GOOG 2/20/04 920 390.320 359,094.40 192.55 453,146.00 94,051.60 26.19% 9 Home Depot HD 11/14/05 770 34.540 26,595.80 31.72 24,424.40 (2,171.40) -8.16% 10 IBM IMB 9/14/04 990 74.080 73,339.20 81.47 80,655.30 7,316.10 9.986 11 Merck MRK 1/14/05 950 42.125 40,018.75 38.34 36,423.00 (3,595.75) -8.99% 12 Sprint Nextel 9/10/03 560 17.790 9,962.40 21.18 11,860.80 1,898.40 19.06% 13 Totals $ 622,665.05 $ 725,992.60 $ 103,327.55 16.59% 14 Average 760 $81.69 $69,1 85.01 $95.81 $80,665.84 $11.480.84 15 Highest 990 $390.32 $359,094.40 $492.55 $453,146.00 $94,051.60 28.49% 16 Lowest 380 $17.79 $9,962.40 $21.18 $11,860.80 ($4,593.60) -9.67% 17 4 , Portfolio Summary./Bod Trie Stock Courtes Figure B a) Write down the formula for the following cell; (8 marks) i. E15 ii. G14 iii. H13 iv. 116 b) In order to create a 3D clustered column chart of current value for all the stocks, which cells in the above table should be selected? (2 marks)