You are the assistant publicist for a best-selling international author who wrote an adventure…

You are the assistant publicist for a best-selling international author who wrote an adventure novel about an improbable around-the-world trip. To promote her new novel, she will leave on a 20-cities-in-30-days book tour that matches the travels her characters had in the book. Her publisher sent a tab-delimited file containing her itinerary. You need to create an Excel workbook that displays current exchange rates for the cities on the tour. The author needs to refer to this worksheet during the trip, so she needs to be able to update the lookup table whenever she can get an Internet connection.

Open the tab-delimited file e09b1tour.txt as a new Excel workbook. Do not create a connection to the original text file. Save the workbook as e09b1tour_LastnameFirstname in Excel Workbook format. Insert a column to the left of the Currency column, and convert the City and Country data into two columns. Adjust column widths, and rename the worksheet Itinerary & Currency. Insert a new worksheet named Currency Lookup, and use the Existing Connections dialog box to create a Web query to the MSN MoneyCentral Investor Currency Rates to create a table of currencies.

On the Itinerary & Currency worksheet, add columns that will calculate the equivalent of $10, $50, and $100 (U.S. dollars) in the local currencies for each stop. Use a lookup function to get the current exchange rate for that country from the Web query table on the Currency Lookup worksheet. Nest the CONCATENATE function inside the lookup function to concatenate the currency label with in US Dollars to find exact matches with labels in the Currency Lookup table, and calculate the U.S. dollar equivalents. Use Format Painter to copy formats from the column labels in the imported Currency Lookup worksheet to the column and row labels in the Itinerary & Currency worksheet. Format the values in both worksheets. Create a footer with your name on the left side, the sheet name code in the center, and the file name code on the right side of each worksheet. Save and close the workbook, and submit based on your instructor’s directions.

Calculate the price
Make an order in advance and get the best price
Pages (550 words)
*Price with a welcome 15% discount applied.
Pro tip: If you want to save more money and pay the lowest price, you need to set a more extended deadline.
We know how difficult it is to be a student these days. That's why our prices are one of the most affordable on the market, and there are no hidden fees.

Instead, we offer bonuses, discounts, and free services to make your experience outstanding.
How it works
Receive a 100% original paper that will pass Turnitin from a top essay writing service
step 1
Upload your instructions
Fill out the order form and provide paper details. You can even attach screenshots or add additional instructions later. If something is not clear or missing, the writer will contact you for clarification.
Pro service tips
How to get the most out of your experience with MyhomeworkGeeks
One writer throughout the entire course
If you like the writer, you can hire them again. Just copy & paste their ID on the order form ("Preferred Writer's ID" field). This way, your vocabulary will be uniform, and the writer will be aware of your needs.
The same paper from different writers
You can order essay or any other work from two different writers to choose the best one or give another version to a friend. This can be done through the add-on "Same paper from another writer."
Copy of sources used by the writer
Our college essay writers work with ScienceDirect and other databases. They can send you articles or materials used in PDF or through screenshots. Just tick the "Copy of sources" field on the order form.
See why 20k+ students have chosen us as their sole writing assistance provider
Check out the latest reviews and opinions submitted by real customers worldwide and make an informed decision.
Thank you!!! I received my order in record timing.
Customer 452551, February 9th, 2021
Classic English Literature
It was my first time using such a service. Essay was good and nicely formatted.
Customer 452441, February 16th, 2022
Thank you so much for your help! :)
Customer 453167, May 11th, 2022
English 101
thank you for the excellent work
Customer 452883, October 29th, 2021
Professions and Applied Sciences
Thanks. This helps a lot. Was a bit late but some cushion was given.
Customer 453015, February 10th, 2022
thank you!
Customer 452947, October 21st, 2021
It's the second time I use this service and it does not let me down. Work quality is so good for its price!
Customer 452985, December 3rd, 2021
thank you so much
Customer 452749, June 10th, 2021
I am beyond eager to write this review for this writer. I received a grade of "Mastered"upon first submission on this assignment. I will shout to the rooftops ENCOURAGING you to hire him. I have used other writers but NONE have delivered such awesome work as this writer and NONE of their prices can compare to his. He does not try to "break the bank" and he works hard; it shows in the final paper and the grade. He is simply,THE BEST HERE!!
Customer 452995, November 16th, 2021
Usually, references need to be within the past 5 years. Thank you :)
Customer 452547, July 16th, 2021
Human Resources Management (HRM)
Very well written and very impressed with this service!
Customer 453077, February 16th, 2022
Thank you , Excellent work
Customer 453201, June 2nd, 2022
Customer reviews in total
Current satisfaction rate
3 pages
Average paper length
Customers referred by a friend
15% OFF your first order
Use a coupon FIRST15 and enjoy expert help with any task at the most affordable price.
Claim my 15% OFF Order in Chat
Live ChatWhatsApp

Are You Looking For Assignment Help? We Can Certainly Assist You