Assignment Detail

Tutors

Evolution of the euro relative to the dollar

    Assignment Instructions

    Assignment ID: FG133049185

    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

    477_Software_For_Business.jpg

    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

     

     

     

    Need fresh solution to this Assignment without plagiarism?? Get Quote Now

    Expert Answer

    Asked by: Anonymous
    Plagiarism Checked
    Answer Rating:
    4.6/5

    Plagiarism free Answer files are strictly restricted for download to the student who originally posted this question.

    Related Assignments

    //
    Our customer support team is here to answer your questions. You can send Assignments directly to support team.
    👋 Hi, how can I help?