Currency Excel Project
Not what you're looking for?
Currency
Project Description:
In this problem, you will convert one currency to another using the assumed exchange rates.
Use a cell reference or a single formula where appropriate in order to receive full credit. Do not copy and paste values or type values.
1) Start Excel. Download and open the workbook named: Chapter_2-1_Currency_Start
2) In cell B12, use the ratio of euros to dollars to convert the amount from cell B9 to euro. Format cell B12 as Currency with euro symbol.
3) In cell B13, use the ratio of yen to dollars to convert the amount from cell B9 to yen. Format cell B13 as Currency with yen symbol.
4) In cell B13, use the ratio of yen to dollars to convert the amount from cell B9 to yen. Format cell B13 as Currency with yen symbol.
5) In cell E13, use the ratio of dollars to yen to convert the amount from cell E9 to dollar. Format cell E13 as Currency with dollar symbol.
6) In cell H12, use the ratio of dollars to euros to convert the amount from cell H9 to dollar. Format cell H12 as Currency with dollar symbol.
7) In cell H13, use the ratio of yen to euros to convert the amount from cell H9 to yen. Format cell H13 as Currency with yen symbol.
8) In cell C17, use the ratio of British pounds to US dollars to convert the amount from cell B17 to pounds. Format cell C17 as Currency with pound symbol.
9) In cell D17, use the ratio of Argentinian pesos to British pounds to convert the amount from cell C17 to Argentinian pesos. Format cell D17 as Currency with ARS symbol.
Assume the ratio of euros to dollars to yen is 3 : 4 : 500.
a.) Given an input of any amount of one currency, enter formulas that output the proportional amount of the other two currencies. Use the ratios of currencies in cells B6:D6 in your formulas. Format as appropriate currency.
b.) Given the exchange rates between US Dollars (USD), British Pounds (GBP) and Argentinian Pesos (ARS); 1.65 USD : 1 GBP and 1 GBP : 13 ARS; please enter the appropriate ratios on the sheet assuming you start with 1 USD. Format as appropriate currency.
Purchase this Solution
Solution Summary
The Excel file contains all formulas, computations and solutions.
Education
- MSc, California State Polytechnic University, Pomona
- MBA, University of California, Riverside
- BSc, California State Polytechnic University, Pomona
- BSc, California State Polytechnic University, Pomona
Recent Feedback
- "Excellent work. Well explained."
- "Can you kindly take a look at 647530 and 647531. Thanks"
- "Thank you so very much. This is very well done and presented. I certainly appreciate your hard work. I am a novice at statistics and it is nice to know there are those out there who really do understand. Thanks again for an excellent posting. SPJ"
- "GREAT JOB!!!"
- "Hello, thank you for your answer for my probability question. However, I think you interpreted the second and third question differently than was meant, as the assumption still stands that a person still independently ranks the n options first. The probability I am after is the probability that this independently determined ranking then is equal to one of the p fixed rankings. Similarly for the third question, where the x people choose their ranking independently, and then I want the probability that for x people this is equal to one particular ranking. I was wondering if you could help me with this. "
Purchase this Solution
Free BrainMass Quizzes
Know Your Linear Equations
Each question is a choice-summary multiple choice question that will present you with a linear equation and then make 4 statements about that equation. You must determine which of the 4 statements are true (if any) in regards to the equation.
Geometry - Real Life Application Problems
Understanding of how geometry applies to in real-world contexts
Graphs and Functions
This quiz helps you easily identify a function and test your understanding of ranges, domains , function inverses and transformations.
Probability Quiz
Some questions on probability
Solving quadratic inequalities
This quiz test you on how well you are familiar with solving quadratic inequalities.