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

Psychology uoa degree planner - Issue resolution process steps - Bpay reference number check - Karen watson crown law - I m taking responsibility for my digital profile by - Importance of interpersonal communication essays - Akita international university ranking - Independent strategy of an organization to change its current environment - Us history - Red bull wall to wall production - Glencoe virtual lab enzyme controlled reactions - Baroque Music Dp - Brandon holthaus net worth - Currys boston lincs phone number - Nasm 75 day study planner pdf - Alteryx question - Metalanguage in the crucible - Newcastle university degree weighting - Group counseling course with Zoom - Sa010 form - Discuss some key terms in business. - Introduction to Speech - Merger and acquisition notes for mba - The honourable wally norman - Physical enablers in aged care - Lab equipment test pdf - Week 1 - Employee department sql queries - The objectification of women whose fault is it - Coca cola case study file type ppt - Brandon gorin net worth - Accented neutral color scheme room - Discussion - Protective security advisor job requirements - Capstone simulation tips - The new colossus questions - Ocean carriers case study solution - Shaw heath medical centre stockport - Security incident and event management ppt - Homozygous or heterozygous worksheet answers - Act 5 scene 2 othello analysis - Ethical hacking - Rapid sand filter design - Doing business today without harming the ability of future generations - Essentials of human anatomy and physiology 12th edition pearson - Need Help with A&P Exam - Can anyone guide the proposal report structure and offer writing help? - Chicago food and beverage company case study - 42.875 as a fraction - Spiky cactus clash of clans - High class indian escorts - 1/2 page in 1 hour - 93 little hobart street welch west virginia street view - Journal for Internship Course - Simplify the fraction 10 20 - Http testingforschools com code - Palo alto networks powerpoint icons - Eileen fisher repositioning the brand summary - Calvin and hobbes bullying - Cbc bearings mount gambier - Kitchen renovation project charter - I nedd help - Ncr atm machine manual - Metric system unit for temperature - Mountain dew harvard case study - Research Project Outline - Analysis - Rotary club of strathfield - Article - Signs of safety appreciative inquiry - 2841 hillside dr burlingame ca - Pre-Calculus homework. 80 question ONLINE - How to calculate evsi from decision tree - Where did agriculture originate - Seniors living sepp nsw - Hidcote gardens ingleby barwick - Jim kawashima walgreens - Netherplace works newton mearns - Dow's trademark finest reserve port tesco - Give me liberty chapter 1 review questions answers - Bank guarantee commonwealth bank - Aspa code of ethics - Simple green industrial cleaner sds - Balloon circumference vs temperature experiment - Laboratory 5 mitosis and meiosis - Religion paper - Week 6 Assignment: Course Project Part I - Nursing - Lord of the flies chapter 7 summary - Economic - CMIT 495 WEEK 1 DISCUSSION - Anthem of doomed youth - Core surgical training rotations - IDS/IPS - Http ga water usgs gov edu wwvisit html - Adulteration in turmeric powder answers - Why does a fall in the value of the australian dollar against the u.s. dollar benefit billabong - Brooklands vip pet products - Aluminium 6061 t6 properties pdf - Sheet resistance calculation example