IT

The assignment is consisted of 3 computational questions that must be solved using spreadsheet and 2 written (open) questions that are related to the computational questions but evaluate application of theory.

• In the computational part, you are asked to apply the calculations and knowledge of spreadsheets studied in class to the scenarios provided.
• In the written part, make reference to the theory studied in class and provide examples to support your points.

You must upload the written answers and the spreadsheet via Turn-it-in. Save your documents with the filename: Axxxxxxx (where xxxxxxx is your last name). (Note: You should save two files. One should be an EXCEL document and the other should be a Word document.)

Make on excel

Part One

1. In the table below are the euro-dollar exchange rates for the first two weeks of October 2019. The data shows dollars per euro. Draw a line chart that shows the evolution of the euro relative to the dollar. Add a trendline.

USD
11/10/2019	1,1043
10/10/2019	1,1030
09/10/2019	1,0981
08/10/2019	1,0986
07/10/2019	1,0993
04/10/2019	1,0979
03/10/2019	1,0951
02/10/2019	1,0925
01/10/2019	1,0898
30/09/2019	1,0889

2. Your company manufactures and exports electrical generators. The table below shows a series of generators and their price in Euros. Create the table in excel. Insert the dollar rate on the 30/09/2019 in the cell below Dollar rate. Create a formula that allows you to see all the prices of the generators in dollars; if the dollar should change then updating the dollar rate cell updates all the prices in the column. Repeat the procedure for the rate on 11/10/2019.

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

Part Two

3. Create a memo in Word. Comment on the trend shown in question 1 above. Is the euro rising or falling?
4. If your businesss products are priced in euros, and assuming the trend shown in question 1 continues, what would be the consequences for your companys exports?

Date Date Dollar rate: Dollar rate: Price in dollars Difference Generator Price in Euros Price in dollars 275 KVA 46890 385 KVA 59890 550 KVA 89990 660 KVA 106790 770 KVA 119790 825 KVA 186900 935 KVA 148890