Excel

Use the following websites and your Excel skills to follow the steps laid out and answer the questions below. You also need to attach your Excel spreadsheet.

Exports: https://www.cia.gov/library/publications/the-world-factbook/rankorder/2078rank.html (Links to an external site.)

Imports: https://www.cia.gov/library/publications/the-world-factbook/rankorder/2087rank.html (Links to an external site.)

Use $153,200,000,000 for Brazil's missing Import figure. It's Export estimate is given.

Use "0" for any other missing information.

Steps to take:

1. Put the "Export" data into an Excel spreadsheet. There is a Download button on the import and export websites. This will download text file. You may have to "Save Page As" from your Browser. If you do, save it as a text file. Open the text file with Excel. If you don't know how, do an internet search on any variety of the words parsing, excel, text file, import, etc. The files don't always download the same, but most likely you will be parsing it with, "Fixed Width." If you have troubles, reach out to your professor.


2. Put the "Import" data into the same Excel spreadsheet - same process as #1.


3. Find the three countries with the largest trade surplus (Maximum (Export - Import)). List the three countries and the dollar amount of their surplus in order on this assignment. In other words, having the answers in the attached spreadsheet is not enough. The answer has to be typed into the Canvas Comments Box. Please disregard the EUROPEAN UNION when reporting your answers. Note that the student will need to combine two spreadsheets to complete this assignment. The suggested process is to use the Excel function, VLOOKUP. If the student is not familiar with this process, it is a good one to know. Search the internet for VLOOKUP or Vertical Lookup. If you have troubles, reach out to your professor.


4. Find the three countries with the largest trade deficit (Maximum (Import - Export)) or (Minimum (Export - Import)). List the three countries and the dollar amount of their deficit in order on this assignment. In other words, having the answers in the attached spreadsheet is not enough. The answer has to be typed into the Canvas Comments Box . Please disregard the EUROPEAN UNION when reporting your answers.


5. Economically, which list would a country rather be on, "Trade Surplus" or "Trade Deficit?" Place your two word answer in the Canvas Comments Box.


6. Attach the spreadsheet showing the entire list of countries and reflecting the $ value of their trade surplus or trade deficit