XIH. Excel Paper Microsoft Excel Product Activation Faill) Page : Formulas Dula Review Vicw Fic Hole PLA Autumn Cli - N Wire Text General Nams Neutral + Calculation Good Exploratory input - Merge & Center S. 4 Conditional Format Tuttigre Table Check Cell Ne Insert Delene Format Serta rin Pate Format Painte Clipboard 021 Tent Aliquant Number CP Ex A B D H L M ND R S 1 1 E G Investments Summary of Investments K A1 to Jl merge and contor, Titic style. Background colour Grecr Ajmerge and center, Background colour Green 4Marks 2 mark Price MARS 2 Marks 4 Marks Stock 3 Company Symbol 4 Apple AAL 5 Caterpillar CAT 6 Disney DIS 7 General Clecht GC Metule MET 9 Microsoft MSFT 10 PepsiCo PEP 11 Target TIGT 12 Wal-Mart WMT 13 Totals Purchase Date 2007-03-03 2008-06-14 2006-10-11 2009-03-04 2008-01-15 2000-11-15 2006-02 13 2004 05 2009.04.14 Price per Shares Share 800 31.00 500 41.00 300 31.06 500 51.00 200 50.00 500 23.20 350 37.80 450 44.11 250 50.81 Initial Cost 24,800.00 20,500.00 4,310.00 40,500.00 17,000.00 14,000.00 20,251.00 19,849,50 12,702.50 120, 121.00 per Share Current Value 75.32 60,256.00 69.00 34,510.00 37.18 11,214.00 4,695.00 15,418.00 35.30 18,150.00 70.05 24,727.50 44.02 19,809.00 57.20 14,300.00 201,079.60 Percent Gain/Lus Gain/ A3 to 1) Raply Heading Style 35,456.00 142.9714 to HIG Accounting style, all other numbers are comma styl 14,010.00 68.34% Fram 4 to 12 apply style and 2 digits after decimal places 1,896.00 20.35% -15,805.00 -88.418 -2,182.00-12.00% 2,350.00 24.32 4,476.50 22.11% 40.50 0.2016 Change height of row 14 to 27 1,597.50 12.58% 22,058.50 189.64% stal Style, Calculate Sum from de to d1.copy for Etol column 3Marks Marks 427.7778 $30.49 $ 800 $ 88.00 $ 200 $29.20 $ 20,013.44 $ 52.93 $ 22,564.39 40,500.00 $77.04 $ 60,256.00 4.310.00 $9.99 $ 4,645.00 4.645.00 2,550.94 21.07% Calculate average from 4 to 12 copy for Eto J columns 35,456.00 142.97% Calculate maximum trom 04 to dl2.copy tor Etol columns -35,805.00 -88.41% Calculate minimum fram d4 to 12,copy for Eto columns Marks Marks Marks 14 Average 15 Highest 16 lowest 17 18 19 Fomula Ic Perment Gain/Los 5 2 ter och formulas marks 20 Initial Cost Current Value Gain/Loss ...please refer to Formule given Shares initial Price per Share Shares Curren Price per Share Gairlos Current Value Vinitial Initial Cost Apply conditional formatting from 54 to 12 Fill background colour with Green for (Initial price per Shore) 50 10 Marks SOMarks 23 24 36 27 30 H4H Ready| Summary of Investments Sheet2 Sheet3 > Type here to search E- F 40 ENG 12:39 PM 21213-05-19 XIH. Excel Paper Microsoft Excel Product Activation Faill) Page : Formulas Dula Review Vicw Fic Hole PLA Autumn Cli - N Wire Text General Nams Neutral + Calculation Good Exploratory input - Merge & Center S. 4 Conditional Format Tuttigre Table Check Cell Ne Insert Delene Format Serta rin Pate Format Painte Clipboard 021 Tent Aliquant Number CP Ex A B D H L M ND R S 1 1 E G Investments Summary of Investments K A1 to Jl merge and contor, Titic style. Background colour Grecr Ajmerge and center, Background colour Green 4Marks 2 mark Price MARS 2 Marks 4 Marks Stock 3 Company Symbol 4 Apple AAL 5 Caterpillar CAT 6 Disney DIS 7 General Clecht GC Metule MET 9 Microsoft MSFT 10 PepsiCo PEP 11 Target TIGT 12 Wal-Mart WMT 13 Totals Purchase Date 2007-03-03 2008-06-14 2006-10-11 2009-03-04 2008-01-15 2000-11-15 2006-02 13 2004 05 2009.04.14 Price per Shares Share 800 31.00 500 41.00 300 31.06 500 51.00 200 50.00 500 23.20 350 37.80 450 44.11 250 50.81 Initial Cost 24,800.00 20,500.00 4,310.00 40,500.00 17,000.00 14,000.00 20,251.00 19,849,50 12,702.50 120, 121.00 per Share Current Value 75.32 60,256.00 69.00 34,510.00 37.18 11,214.00 4,695.00 15,418.00 35.30 18,150.00 70.05 24,727.50 44.02 19,809.00 57.20 14,300.00 201,079.60 Percent Gain/Lus Gain/ A3 to 1) Raply Heading Style 35,456.00 142.9714 to HIG Accounting style, all other numbers are comma styl 14,010.00 68.34% Fram 4 to 12 apply style and 2 digits after decimal places 1,896.00 20.35% -15,805.00 -88.418 -2,182.00-12.00% 2,350.00 24.32 4,476.50 22.11% 40.50 0.2016 Change height of row 14 to 27 1,597.50 12.58% 22,058.50 189.64% stal Style, Calculate Sum from de to d1.copy for Etol column 3Marks Marks 427.7778 $30.49 $ 800 $ 88.00 $ 200 $29.20 $ 20,013.44 $ 52.93 $ 22,564.39 40,500.00 $77.04 $ 60,256.00 4.310.00 $9.99 $ 4,645.00 4.645.00 2,550.94 21.07% Calculate average from 4 to 12 copy for Eto J columns 35,456.00 142.97% Calculate maximum trom 04 to dl2.copy tor Etol columns -35,805.00 -88.41% Calculate minimum fram d4 to 12,copy for Eto columns Marks Marks Marks 14 Average 15 Highest 16 lowest 17 18 19 Fomula Ic Perment Gain/Los 5 2 ter och formulas marks 20 Initial Cost Current Value Gain/Loss ...please refer to Formule given Shares initial Price per Share Shares Curren Price per Share Gairlos Current Value Vinitial Initial Cost Apply conditional formatting from 54 to 12 Fill background colour with Green for (Initial price per Shore) 50 10 Marks SOMarks 23 24 36 27 30 H4H Ready| Summary of Investments Sheet2 Sheet3 > Type here to search E- F 40 ENG 12:39 PM 21213-05-19