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

Assignment 1 - Arcair k4000 parts manual - Informative outline example - Positive transfer of skills examples - The practical skeptic readings in sociology 5th edition pdf - Let your light shine theme - Hoyt sector model pdf - EMERGING WEEK 2 DQ - Chronic Kidney Disease - 8 aesthetic principles - Political scientist harold lasswell defined politics as - Affidavit family court wa - Introduction of recrystallization of naphthalene - West coast transit case study - Fiona dolman new tricks - Guidedogs org uk raffle - Hsbc stephen and stitt - Discussion 300 WORDS MINIMUM - Was macbeth a general - Pid controller circuit design - Bio rad restriction enzyme lab - Thermodynamics borax lab report - Timber roof batten span tables - W.b yeats the second coming - Bernoulli's theorem experiment lab report - Sony history and background - Testing and commissioning plan template - Economics assignment - Ethical decision making in project management - Operations Management - Whs performance reporting matrix - Crm string workflow utilities - The profits earned from rice persuaded carolina planters to - Ich bin ein berliner analysis - Bsbwor203 work effectively with others answers - Operational Planning - Maximum megahertz project action plan - Hunter united credit union login - Organ leader dis - Leadership in Nursing - The first cross cultural missionary team was - Duke university financial engineering - Bernie madoff powerpoint presentation - Margin of safety in dollars - Re expressing data definition - Detox for life nuzum - Captive wild animal management - 60 psi to mpa - Greg lynn folding in architecture - Dilbert mission statement generator website - Economic and Political Globalization - Jcu withdrawal without academic penalty - Operational Excellence - crisis management final project - Week 2 discussion - Jackie kay carol ann duffy relationship - Trailer axle installation guide - Camp green lake warden - Dhs ambulatory care network harbor ucla - Wk 1, IOP 490: DR 1 - Building certifiers alice springs - International political economy ppt - Fresno state business major - Roland corporation brand positioning - Apply: Regression, Use the data to construct a model, Construct a multiple regression model. - Http www learner org courses envsci interactives carbon - Case study on performance management pdf - Triangle inequality theorem practice - Mark dransfield net worth - Queens hospital romford blood test - Geeks by jon katz sparknotes - A random sample of 10 shipments of stick-on labels showed the following order sizes. - In Python - Melting point determination lab report - Gippsland tafe yallourn campus - Anne of green gables chapter 11 - Scotch 700 adhesive cleaner and solvent - Concrete downpipe sump box - Which sequence correctly summarizes the accounting process - Problem 11 2a entries for payroll transactions lo p2 p3 - Kings road college plymouth courses - 5 cheeky monkeys teasing mr crocodile - Pm international business plan pdf - What is unrelated diversification strategy - How is macy's positioned in the fashion market - Write a note on managerial reporting - Assonance in jfk inaugural address - Perspex rod static electricity - Unlocking the Secrets of Success: A Journey to Excellence - What does quaint mean in the raven - Algorithm to solve a 2x2 rubik's cube - Teaching mood in literature - Noncallable bonds that mature in 10 years - Produce offspring crossword clue - One pole one zero filter - I ask my mother to sing poem analysis - Math internet scavenger hunt - 50 conductor cable color code - Zhan's radcliffe on trent - How to find union of two independent events