Hello, I\'m doing some last minute hw for business info. systems and needed help

Question

Hello,

I'm doing some last minute hw for business info. systems and needed help doing this, thank you in advance.

Project 5: Convert Currency You have decided to spend the su rance, England, taly, Switzerland, Germany, Norway, and Ireland. You want to use Excel to convert Locate one of the exchange rate calculators on the Internet (www.xe.com or www currencies as you travel around the world. .x-rates.com). Find the exchange rates for each of the listed countries and create formulas in Excel to convert $100, $500, and $1,000. Use the data file AYK5_ Data.xlsx data file as a template. Data File: AYK5 Data.xls

Explanation / Answer

Answer:

Working Notes for the above answer is as under

First of all we will calculate the exchange rater of each country as per rate given in the sum as follow

1

We have been given that 1 USD= 0.534 British Pound

2

We have been given that 1 USD= 0.789 EUR

3

We have been given that 1 USD= 1.251 Swiss France

4

1 USD= 6.534 Norwegian Krone

US Dollar England EU Euro Switzer Land` Norway 100 53.4 78.9 125.1 653.4 500 267 394.5 625.5 3267 1000 534 789 1251 6534

Related Questions

Navigate

• Browse (All)
• Browse H
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.