1. Review the data carefully. You will notice that revenue is expressed in Euros (EUR) or Dollars (USD) depending on where the sales originate. Create a new calculated column to compute the revenue as US Dollars only. Name the new calculated column Revenue(USD) and use an exchange rate of 1.14 dollars per euro. (Hint: IF formula).

L M None J J Revenue Revenue USD 21.65 43.3 86.6 129.9 86.6 151.55 281.45 21.65 108.25 129.9 129.9 129.9 606.2 303.1 Currency Discount NetSales EUR Currency Sort EUR Ascending Descending EUR By color: None EUR Filter EUR By color: EUR Choose One EUR Search EUR (Select All) EUR EUR USD EUR EUR EUR EUR Clear Filter EUR 1 PII