Loading...

Messages

Proposals

Stuck in your homework and missing deadline? Get urgent help in $10/Page with 24 hours deadline

Get Urgent Writing Help In Your Essays, Assignments, Homeworks, Dissertation, Thesis Or Coursework & Achieve A+ Grades.

Privacy Guaranteed - 100% Plagiarism Free Writing - Free Turnitin Report - Professional And Experienced Writers - 24/7 Online Support

How to convert cad to usd in excel

26/10/2021 Client: muhammad11 Deadline: 2 Day

ITEC-200 Excel International Finance Homework Instructions

1

Technical Learning Objectives (How it works)

• Download and format reference data

• IF and VLOOKUP Statements

• External connection for XML data

• Pivot Table & Chart

• Insert a textbox

Business Learning Objectives (How you use it)

• Understand basics of international finance by using revenue in different currencies.

• Convert values in different currencies to a common currency (USD, in this case).

• Interpret a chart.

Problem Statement

Your client has customers in different countries who place orders in multiple currencies. However, they need to do financial reporting in US Dollars for a certain period of time but revenue comes in from the 10 most heavily-traded currencies in the world (see below; source: https://en.wikipedia.org/wiki/Templ ate:Most_traded_currencies).

Rank Country Currency ISO 4217

Code ISO 4217 Symbol

1   United States Dollar USD $

2   Euro EUR €

3   Japanese Yen JPY ¥

4   Pound Sterling GBP £

5   Australian Dollar AUD A$

6   Canadian Dollar CAD C$

7   Swiss Franc CHF Fr

8   Chinese Renminbi CNY 元

9   Swedish Krona SEK kr

10   New Zealand Dollar NZD NZ$

Instructions

Start by downloading the Excel file and rename it to 'ITEC200-00X_last name_first name_Homework2' where 00X = your section number. In order to complete this assignment, you will need to download International Standards Organization (ISO) Country Codes and Currency Codes, use VLOOKUP to convert codes to plain English names, use an XML source to get current Exchange Rates, use an IF/VLOOKUP to convert local currency values to USD, create a Pivot Table and Chart, then interpret the data. 1. Since sales data contain raw codes (i.e., not mapped to plain English values), you will need to use

VLOOKUP to find them. However, you must first import the mapping data from the text files included with this assignment. Copy-and-paste the codes into worksheet names of 'Country Codes' and 'Currency Codes' respectively and format all cells appropriately. [4% of grade]

2. In order to get current currency exchange rates, you will need to connect your Excel file to an

external datasource, in this case, an XML file stored on a webpage at: http://www.floatrates.com/ daily/usd.xml, which you should review so you understand the data you will be downloading. (Note: XML or Extensible Markup Language, is a computer language that allows transmission of textual

https://en.wikipedia.org/wiki/Template:Most_traded_currencies
https://en.wikipedia.org/wiki/Template:Most_traded_currencies
https://en.wikipedia.org/wiki/ISO_4217
https://en.wikipedia.org/wiki/ISO_4217
https://www.iso.org/home.html
http://www.floatrates.com/daily/usd.xml
http://www.floatrates.com/daily/usd.xml
https://en.wikipedia.org/wiki/XML
ITEC-200 Excel International Finance Homework Instructions

2

data that is both human- and machine-readable and across different platforms. For a 2-minute explanation of XML, please watch https://www.youtube.com/watch?v=tZE-O5KTwCY). [25% of grade] This assignment is based on the Windows version of Excel 2016 of which there are two, different versions – Excel 2016 and Excel 2016 Professional Plus. This section file contains instructions for both subversions. If you are a Mac user, you should use the Virtual Computing Lab (VCL) at: https://vcl.american.edu/ to complete this assignment. a. Excel 2016 Instructions for Windows To get these external data, you will need to use Excel's Get & Transform Data feature found under the Data Tab. Select Get Data → From Web (below left), which will bring up a dialog box (below, right).

Enter the URL and select OK then select Edit as shown below.

This brings up another window for the Query Editor, which allows you to edit which columns of data are imported into Excel when you click on the far-right column of Item.

https://www.youtube.com/watch?v=tZE-O5KTwCY
https://vcl.american.edu/
ITEC-200 Excel International Finance Homework Instructions

3

This brings up the following dialog box. Select the following

columns: pubDate, baseCurrency, baseName, target

Currency, targetName, and exchangeRate, then select Close

and Load. Your worksheet should now show all the needed

exchange rate data. Label this worksheet 'Exchange Rates'.

b. Excel 2016 Professional Plus Instructions (version found on the VCL) To get the XML download, click on Data → Get External Data → From Web, which brings up the

dialog box below. Enter the URL http://www.floatrates.com/daily/usd.xml and click Go.

If you get a JavaScript error like shown below, click Yes until it goes away.

http://www.floatrates.com/daily/usd.xml
ITEC-200 Excel International Finance Homework Instructions

4

Scroll down within the New Web Query window until you can the Exchange Rates for U.S. Dollar

(USD) table and click the icon, which will highlight in blue the data you need.

ITEC-200 Excel International Finance Homework Instructions

5

You will then get a prompt as to where to put the data. Click on New Worksheet (see below).

This will retrieve the following three columns: Currency Name, Code, and Rate per 1 USD (see sample

below), which is all the data you need to complete the IF/VLOOKUP statements. Label this worksheet

'Exchange Rates'.

*** End of XML download instructions. ***

3. Looking at the Sales Data worksheet, add columns so that your header row looks like below. [1% of grade]

Order ID

ISO Code

Country Name

Order Currency

Order Currency

Name

Quantity Ordered

Unit Price

Order Total

Exchange Rate

USD Total

ITEC-200 Excel International Finance Homework Instructions

6

4. Create formulas for the following columns and format all cells appropriately [40% of grade]:

Country Name: VLOOKUP Order Currency Name: VLOOKUP Order Total = Quantity Ordered * Unit Price Exchange Rate: VLOOKUP USD Total = Order Total/Exchange Rate

5. Add a worksheet labeled 'Pivot Chart' and move it so that it's the first one on the left. Then create a

Pivot Chart (Column Chart) showing Country Name and Sum of USD Total. Format all cells appropriately. The order of worksheets should be: Pivot Chart, Sales Data, Exchange Rates, Country Codes, and Currency Codes [15% of grade]

6. Add a textbox next to the Pivot Chart and answer the following questions; do not repeat the

questions in your answers. [15% of grade]

1. Assume your boss asked you to summarize the results in a paragraph. What would you tell them? An assessment such as "It tells us how much revenue came from each country." would be true of any chart like this; you are being asked to say what this chart tells you.

2. What questions would you ask so you could better understand what the data tell you? Think about what data or detail beyond what you were given might be useful.

Homework is Completed By:

Writer Writer Name Amount Client Comments & Rating
Instant Homework Helper

ONLINE

Instant Homework Helper

$36

She helped me in last minute in a very reasonable price. She is a lifesaver, I got A+ grade in my homework, I will surely hire her again for my next assignments, Thumbs Up!

Order & Get This Solution Within 3 Hours in $25/Page

Custom Original Solution And Get A+ Grades

  • 100% Plagiarism Free
  • Proper APA/MLA/Harvard Referencing
  • Delivery in 3 Hours After Placing Order
  • Free Turnitin Report
  • Unlimited Revisions
  • Privacy Guaranteed

Order & Get This Solution Within 6 Hours in $20/Page

Custom Original Solution And Get A+ Grades

  • 100% Plagiarism Free
  • Proper APA/MLA/Harvard Referencing
  • Delivery in 6 Hours After Placing Order
  • Free Turnitin Report
  • Unlimited Revisions
  • Privacy Guaranteed

Order & Get This Solution Within 12 Hours in $15/Page

Custom Original Solution And Get A+ Grades

  • 100% Plagiarism Free
  • Proper APA/MLA/Harvard Referencing
  • Delivery in 12 Hours After Placing Order
  • Free Turnitin Report
  • Unlimited Revisions
  • Privacy Guaranteed

6 writers have sent their proposals to do this homework:

Professional Accountant
Supreme Essay Writer
Professor Smith
Top Quality Assignments
WRITING LAND
Top Academic Guru
Writer Writer Name Offer Chat
Professional Accountant

ONLINE

Professional Accountant

As per my knowledge I can assist you in writing a perfect Planning, Marketing Research, Business Pitches, Business Proposals, Business Feasibility Reports and Content within your given deadline and budget.

$27 Chat With Writer
Supreme Essay Writer

ONLINE

Supreme Essay Writer

I have done dissertations, thesis, reports related to these topics, and I cover all the CHAPTERS accordingly and provide proper updates on the project.

$16 Chat With Writer
Professor Smith

ONLINE

Professor Smith

I have read your project description carefully and you will get plagiarism free writing according to your requirements. Thank You

$40 Chat With Writer
Top Quality Assignments

ONLINE

Top Quality Assignments

I am an elite class writer with more than 6 years of experience as an academic writer. I will provide you the 100 percent original and plagiarism-free content.

$43 Chat With Writer
WRITING LAND

ONLINE

WRITING LAND

Being a Ph.D. in the Business field, I have been doing academic writing for the past 7 years and have a good command over writing research papers, essay, dissertations and all kinds of academic writing and proofreading.

$26 Chat With Writer
Top Academic Guru

ONLINE

Top Academic Guru

I reckon that I can perfectly carry this project for you! I am a research writer and have been writing academic papers, business reports, plans, literature review, reports and others for the past 1 decade.

$24 Chat With Writer

Let our expert academic writers to help you in achieving a+ grades in your homework, assignment, quiz or exam.

Similar Homework Questions

Five step marketing research approach - Discussion paper - Interpreting motion graphs worksheet answers - Titanic analysis essay - Hospital management system desktop application - How many feet in 18 yards - Essay - Ntsb investigation process - Abbreviated electron configuration of tellurium - Benjamin leon school of nursing - Workshop statistics discovery with data exercise answers - Week 8 Signature Assignment Final Paper Attempt - Probationary period evaluation template - Bs 5268 part 2 - 10 page essay compare and contrast Missouri and us constitution - Lorenzo negrete yo soy mexicano - 521 Week 5 Field Activity Paper - Financial accounting chapter 10 solutions - Understanding and managing diversity 6th edition pdf - Internet Crime and Virus Hoaxes - Illusions are valuable to psychologists because they are used to - Activity based costing ups - Los cajeros cuentan los palillos para saber cuánto deben pagar los clientes - Dmv insurance codes ny - Which ethical system embraces human's inclination for self preservation - Disaster management in community health nursing - Self-introduction - Apply for special consideration rmit - +91-8306951337 vashikaran specialist near me IN Salem - Connect extend challenge worksheet - Hku main library opening hours - Solubility product constant and common ion effect lab answers - Pes statement for diabetes type 2 - Prepare Work for Your "Positive Structural Change" Project. - Today's forecast equals yesterday's actual demand is referred as - Stylistic equivalence in translation - Capacitated plant location model supply chain - Human resources - MBA - Main - Set 10 - Examples of symbolism in literature - Mahalia do not disturb chords - How to spot a witch by adam goodheart worksheet - Poems about violence and crime - Types of stem and leaf plots - For researcher_d - Reading level assessment tool - Songimvelo kromdraai camp site elukwatini - Modern garden architecture ppt - Which of the following correctly describes the accounting treatment for interest payable? - Organizational structure of fda - Nt2580 project part 2 - Regional manager job titles - Advanced Financial Accounting - Comprehensive Consolidation Method - Themes in god's bits of wood - Who benefits from subsidies to us sugar producers who loses - Discussion Board - Discussion - Seafood workers in the industrial revolution - Purple cow activity answers - Heart rate assignment - A german worker takes 400 hours - What can limit the stylistic choices of a filmmaker - 800m weight training program - Actinic keratosis nice cks - Module 2 Paper - Technical memo template word - Estee lauder presidential management associate salary - Lego group strategic analysis review - Coke zero and mentos - Theories to determine moral status of a fetus - Case study - Research Paper - How to make glow sticks glow brighter - Hooda math word search - Seebeck coefficient of iron - Image Analysis - Bus stirling to callander - Situation Analysis - Atp pc fuel source - Real world psychology w wileyplus acc - Unit III Scholarly Activity - 3 chloro 3 7 dimethyloctane - The right to be heard implies that companies should listen to consumer complaints and - Discussion Question ONE TO TWO PARAGRAPHS - Capstone Research Companion - Discussion post in regards to research methods experience from a student point of view. - World War 2 - Icd 10 code for thoracentesis - Aplia access code free - A streetcar named desire themes - In kind contribution definition - Benchmark literacy lesson plan template - Human cardiovascular physiology blood pressure and pulse determinations - Kaba time clock configuration - Zara information technology strategy - Research Paper - 10 pages - Costco 6 rights of merchandising - Can 2 blue eyed parents make brown - Paper on 3 articles - Anthropology - Howard smith paper northampton