Reference no: EM133049185

SOFTWARE FOR BUSINESS COURSE

Please help with Question 2 and 3

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.

Date	USD
10/9/18	10,971
9/9/18	11,026
8/9/18	10,835
7/9/18	10,695
6/9/18	10,653
5/9/18	10,422
4/9/18	10,247
3/9/18	10,361
2/9/18	10,132
1/9/18	10,006

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 dollar rate on the 01/09/2018 in the cell below ´ ´Dollar rate ´ ´. Create a formula that allows you to see all the prices of the models in dollars; if the dollar rate changes, the dollar rate cell updates all the prices in the column. Repeat the procedure for the rate on 10/09/2018.

3. In the column marked difference, show the difference in dollars between the two dates.

		Date	Date
		1/9/18	10/9/18
		Dollar rate	Dollar rate
Model	Price in euros	Price in dollars	Price in dollars	Difference
300 VRG	46900
625 RTM	66700
475 GRM	96100
200 GRM	122600
650 MTY	164900
600 RTM	214400
500 MTY	247300