TUT 1. In the table below are the euro-dollar exchange rates for the first ten days of September 2018. The data shows dollar per euro. Draw a line chart that shows the evolution of the euro relative to the dollar. Add a trendline. USD 10/09/2018 1,0971 09/09/2018 1,1026 08/09/2018 1,0835 07/09/2018 1,0695 06/09/2018 1,0653 1,0422 05/09/2018 04/09/2018 1,0247 03/09/2018 1,0361 02/09/2018 1,0132 01/09/2018 1,0060 2. Your company manufactures and exports electric generators. The table below shows a series of models and their price in Euros. Create the table in Excel Insert the doftar rate on the 01/01/2018 in the cell below "Dolar rate Create a formula that allows you to see all the prices of the models in dollar if the dollar rate changes, the dollar rate cell updates all the prices in the column Hepeat the procedure for the rate on 10/01/2018 in the column marked difference show the difference in dollars between the two date. Date Date Dollar rate Dollar rate Price in dollars Price in dollars Difference Model 300 VRG 625 RTM 475 GRM 200 GRM 650 MTY 600 RTM 500 MTY Price in euros 46900 66700 96100 122600 164900 214400 247300 Part two 4. days? Create a memo in Word. Comment on the trend shown in question 1 above. During the first 5 days, was the euro rising or falling? And during those 10 5. Most of your exports to the US belong to the model 600 RTM. The experience shows that, If the price of this product rises over 215000 dollars, the exported units will be reduced. If this product is priced in euros, and assuming the trend shown in question I continues, what would be the consequences for your company's exporta? TUT 1. In the table below are the euro-dollar exchange rates for the first ten days of September 2018. The data shows dollar per euro. Draw a line chart that shows the evolution of the euro relative to the dollar. Add a trendline. USD 10/09/2018 1,0971 09/09/2018 1,1026 08/09/2018 1,0835 07/09/2018 1,0695 06/09/2018 1,0653 1,0422 05/09/2018 04/09/2018 1,0247 03/09/2018 1,0361 02/09/2018 1,0132 01/09/2018 1,0060 2. Your company manufactures and exports electric generators. The table below shows a series of models and their price in Euros. Create the table in Excel Insert the doftar rate on the 01/01/2018 in the cell below "Dolar rate Create a formula that allows you to see all the prices of the models in dollar if the dollar rate changes, the dollar rate cell updates all the prices in the column Hepeat the procedure for the rate on 10/01/2018 in the column marked difference show the difference in dollars between the two date. Date Date Dollar rate Dollar rate Price in dollars Price in dollars Difference Model 300 VRG 625 RTM 475 GRM 200 GRM 650 MTY 600 RTM 500 MTY Price in euros 46900 66700 96100 122600 164900 214400 247300 Part two 4. days? Create a memo in Word. Comment on the trend shown in question 1 above. During the first 5 days, was the euro rising or falling? And during those 10 5. Most of your exports to the US belong to the model 600 RTM. The experience shows that, If the price of this product rises over 215000 dollars, the exported units will be reduced. If this product is priced in euros, and assuming the trend shown in question I continues, what would be the consequences for your company's exporta