Description

Task

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.)

Questions: (Each question is 20% of the assignment)

Part One

1.    In the table below are the euro-dollar exchange rates for the first ten days of August 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/08/2018         1,0698                                                                                                                  

                09/08/2018         1,0886                                                                                                                  

                08/08/2018         1,0688                                                                                                                  

                07/08/2018         1,0778                                                                                                                  

                06/08/2018         1,0643                                                                                                                  

                05/08/2018         1,0848                                                                                                                  

                04/08/2018         1,0712                                                                                                                  

                03/08/2018         1,0457                                                                                                                  

                02/08/2018         1,0390                                                                                                                  

                01/08/2018         1,0149                                                                                                                  

2.    Your company manufactures and exports industrial machinery. 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/08/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/08/2018.                                                                                                                                                               

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

Part two                                                                                                                                                              

4.      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 days?