Is there a way that I can send you the file attachment. The only option for me when posting a question is to take a pic or attach a pic. Need to send the file.
This is a repost with hopefully better visability. The questions are on the right & that is the entire spreadsheet. Zooming in on the spreadsheet looks great. The only other option would be to send the file but need a way to do it. Please show work so that I can understand how to answer the problems. Thank you in advance. 
01 01 01 34 8 1,1 -01-11-01-10-01-01-00 01 01 01 0 1-11-02, 2, 2-2-02-2-0222-2-o 10 01 01 01 01 01 12-ch 02-03-04 05-06 07 08-09 10-11-12 01 02 01 0406 07 09 This sheet contains monthly exchange rate Value of each currency is quoted in 1. Which currency has the highest average percentage change (in absolute term) For each currency,you calculate percentage change for each month Then get the average percentage change Use absolute value of the average above. This absolute average shows you how exchange rate changes regr radless of direction (up/down) 2. Which currency has the hi rd deviation of 3.On 2010-01-01, your company has: CAD UPY MXN 1,000,000 100,000,000 5,000,000 THB 100,000,000 How much all these 4 positions worth in USD 4. If your company hold these 4 positions until 2011-01-01 How all these 4 positions worth in USD 5. If your company holds these 4 positions for the whole period we analyze (2010/01/01-2013/02/01) Which month the total USD value of these 4 positions is highest. put your answer in format yyyymm (201101) Each year, create a table for average monthly percentage for each currency which currency has all 4 averagenumbergreaterthan-0.01%? CAD1 2010 2011 2012 2013 1 1 DATE 03030.0087 1.4266 0.1465 1.6158 0.0218 0.7161 2010-02-01|1.0572/-0.0111 -00773-003020.0087 -130801-0.1464/ 15618 00216 0708 1.02291 00110|. 0079600308| 0.0088 13570-0. 1465| 15058100220| 0.7146 00773 00302 0.0087300.1464 15618 0.0216 1.0052-00107| 00817| 00310| 0.0088| 13417| 01465 15332 78 00309 0.00882563 0.1465 1.4669 00218 07174 01-1 .0376|00110 00787 -0.03081, 0.0088-1.2223 -0.1467 4768 - 0 215-07155 2010-07-01 1.0422 00114 2010-08-011.0404 0 0117 0.0781 00310 0.0089 128110,1476 15304 00214 0.0783 00315 0.0089 290301473 1.5681 - 1.03301 00119 00781 00325 0.00891.31030.14841-15591i-002181 0750 804 0.03340.0090 3901 0.1500 1.5867 002250.7677 0811| 0.03351 0.0090 13654 | 01503| 15961 00223| 07700 0.1504 15595 00222 0.7655 2011-01-01 0.9939 - 00121 008251 00327| 0.00%) 13371 | 01516| 15782 002201-07774 2010-10-01 1.0179 00122 2010-11-01 1.0129 00121 2010-12-01 1.0081 00120 0080700332 0.0090 2011-02-01-09876-0.0121 2011-03-01 0.9 001210.0829 0 0326 00090 1.3656 1521 1.612400220 9766 0012200834 00330 0.0091 402001523 1.6159 0 02230.7888 0.0120 00854 0.0333 0.0091 14460 0.1532 2011-05-01 0.9680 0.01230 00858 0.0331 0.00911.433 01539 1.6332 00223 011-06-010.9766 00124 0.0847 00328 0.00914403 0 1544 1.6219 0022308108 2011-07-01 0.9553 0.0126 2 0.08570 0333 0.0091 142750.15491.6158 2011.08-01 0.9817 001300081700335 0.00911.4333 01562 16356 0022108272 01109-01 1.0025 00130 0076500328 0.0091 1.3747 0,156515771 0021007976 011-10-01 1.0198 00130 00744 00324 0.0091 13732 01570 1,5768 00203 07839 2011-11-01 1.0248 0.0129 007300 0323 0.00901.3558 0.1573 1.580 00197 0.7760 2011-12-01 1.0235 00129 0072600321 0.0088 1.31550.1575 15587 0019107720 2012-01 01 10130 00130 00747 00317 0.008812910 0.1583 1.5524 00196 2012-02-01-0.9967-00127-0.0782-0.0326 0.0085| 1.3238 2012-03-010.9938 0012100784 00326 0.0080 13208 0.1584 1.5824 0 0199 0.1587 0.0203 0.7978 0.7943 2012-04-01:0.9928-00123 00766 0.0324/ 0.0078 13160 0.1586 16000 00193 07994 201205-01 10097 0012600734 0.030 0.0078 12806 0.1581 15924 00184 07924 00718 -0.03160.0076) 12541 01572-15558-0.0179 - 07822 2012-07-01 1.0142 001270.0748 00316 0.0075 1.2278 0.1569 559310 0.7935 2012-08-01 0.9924 0012700759 00319 0.0076 12406 0.1573 1.5722 00180 08013 2012-06-01 1,0280-0012 12012-09-01 | 0.9783| 00128| 00774| 0.0323| 0.0076|1.2885| -Q1582| 16126| 00184| O8128 2012-10-01 | 0.9872 001271 0.0775 0.0326 0.0077 1.2974| 01597|-16080| 00188| O8172 2012-11-01 0.9970 001230.0765 00326 0.0077 128370.1604 1.5968 00183 08175 2012-12-01 0.9898 0.0119 00777 0.0327 0.0078 1.3119 0.1604 16145 00183 0.8194 2013-01-01 -0.9921 0 0112-00788 -00333 0.0079 -- 13304--0 1607 - 1596s l-00184-08142 2013-02-01 1.0052 0.0107 00787 0.0335 0.0079 1.3412 0.1604 1.5563 001860 8076 01 01 01 34 8 1,1 -01-11-01-10-01-01-00 01 01 01 0 1-11-02, 2, 2-2-02-2-0222-2-o 10 01 01 01 01 01 12-ch 02-03-04 05-06 07 08-09 10-11-12 01 02 01 0406 07 09 This sheet contains monthly exchange rate Value of each currency is quoted in 1. Which currency has the highest average percentage change (in absolute term) For each currency,you calculate percentage change for each month Then get the average percentage change Use absolute value of the average above. This absolute average shows you how exchange rate changes regr radless of direction (up/down) 2. Which currency has the hi rd deviation of 3.On 2010-01-01, your company has: CAD UPY MXN 1,000,000 100,000,000 5,000,000 THB 100,000,000 How much all these 4 positions worth in USD 4. If your company hold these 4 positions until 2011-01-01 How all these 4 positions worth in USD 5. If your company holds these 4 positions for the whole period we analyze (2010/01/01-2013/02/01) Which month the total USD value of these 4 positions is highest. put your answer in format yyyymm (201101) Each year, create a table for average monthly percentage for each currency which currency has all 4 averagenumbergreaterthan-0.01%? CAD1 2010 2011 2012 2013 1 1 DATE 03030.0087 1.4266 0.1465 1.6158 0.0218 0.7161 2010-02-01|1.0572/-0.0111 -00773-003020.0087 -130801-0.1464/ 15618 00216 0708 1.02291 00110|. 0079600308| 0.0088 13570-0. 1465| 15058100220| 0.7146 00773 00302 0.0087300.1464 15618 0.0216 1.0052-00107| 00817| 00310| 0.0088| 13417| 01465 15332 78 00309 0.00882563 0.1465 1.4669 00218 07174 01-1 .0376|00110 00787 -0.03081, 0.0088-1.2223 -0.1467 4768 - 0 215-07155 2010-07-01 1.0422 00114 2010-08-011.0404 0 0117 0.0781 00310 0.0089 128110,1476 15304 00214 0.0783 00315 0.0089 290301473 1.5681 - 1.03301 00119 00781 00325 0.00891.31030.14841-15591i-002181 0750 804 0.03340.0090 3901 0.1500 1.5867 002250.7677 0811| 0.03351 0.0090 13654 | 01503| 15961 00223| 07700 0.1504 15595 00222 0.7655 2011-01-01 0.9939 - 00121 008251 00327| 0.00%) 13371 | 01516| 15782 002201-07774 2010-10-01 1.0179 00122 2010-11-01 1.0129 00121 2010-12-01 1.0081 00120 0080700332 0.0090 2011-02-01-09876-0.0121 2011-03-01 0.9 001210.0829 0 0326 00090 1.3656 1521 1.612400220 9766 0012200834 00330 0.0091 402001523 1.6159 0 02230.7888 0.0120 00854 0.0333 0.0091 14460 0.1532 2011-05-01 0.9680 0.01230 00858 0.0331 0.00911.433 01539 1.6332 00223 011-06-010.9766 00124 0.0847 00328 0.00914403 0 1544 1.6219 0022308108 2011-07-01 0.9553 0.0126 2 0.08570 0333 0.0091 142750.15491.6158 2011.08-01 0.9817 001300081700335 0.00911.4333 01562 16356 0022108272 01109-01 1.0025 00130 0076500328 0.0091 1.3747 0,156515771 0021007976 011-10-01 1.0198 00130 00744 00324 0.0091 13732 01570 1,5768 00203 07839 2011-11-01 1.0248 0.0129 007300 0323 0.00901.3558 0.1573 1.580 00197 0.7760 2011-12-01 1.0235 00129 0072600321 0.0088 1.31550.1575 15587 0019107720 2012-01 01 10130 00130 00747 00317 0.008812910 0.1583 1.5524 00196 2012-02-01-0.9967-00127-0.0782-0.0326 0.0085| 1.3238 2012-03-010.9938 0012100784 00326 0.0080 13208 0.1584 1.5824 0 0199 0.1587 0.0203 0.7978 0.7943 2012-04-01:0.9928-00123 00766 0.0324/ 0.0078 13160 0.1586 16000 00193 07994 201205-01 10097 0012600734 0.030 0.0078 12806 0.1581 15924 00184 07924 00718 -0.03160.0076) 12541 01572-15558-0.0179 - 07822 2012-07-01 1.0142 001270.0748 00316 0.0075 1.2278 0.1569 559310 0.7935 2012-08-01 0.9924 0012700759 00319 0.0076 12406 0.1573 1.5722 00180 08013 2012-06-01 1,0280-0012 12012-09-01 | 0.9783| 00128| 00774| 0.0323| 0.0076|1.2885| -Q1582| 16126| 00184| O8128 2012-10-01 | 0.9872 001271 0.0775 0.0326 0.0077 1.2974| 01597|-16080| 00188| O8172 2012-11-01 0.9970 001230.0765 00326 0.0077 128370.1604 1.5968 00183 08175 2012-12-01 0.9898 0.0119 00777 0.0327 0.0078 1.3119 0.1604 16145 00183 0.8194 2013-01-01 -0.9921 0 0112-00788 -00333 0.0079 -- 13304--0 1607 - 1596s l-00184-08142 2013-02-01 1.0052 0.0107 00787 0.0335 0.0079 1.3412 0.1604 1.5563 001860 8076
