Gamez Maravilla_Chapter_2-1_Currency_Start (2) AutoSave OFF A A Calibri (Body) Wrap Text v General 16 LE Paste Cell Styles В I Conditional Format Formatting as Table $ Inse Merge & Center U v 00 0 fx Currency A1 A C D G Н К L м N P R Currency 1 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, as you will not receive full credit for your answers 2 3 Ratio of Currencies Dollars 3.00 4 Assume the ratio of euros to dollars to yen is 3 4:500. Euros Yen $4.00 5 Y500.00 6 7 8 Input Input Input Euros 200.00 Yen: X4,000.00 € 60.00 9 Dollars: 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. а.) а.) а.) 10 Outputs Outputs Outputs 11 12 Euros: Dollars Euros: Dollars 13 Yen: Yen: 14 b.) b.) ARS 15 GBP USD 16 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 $1.00 17 18 the appropriate ratios on the sheet assuming you start with 1 USD. Format as appropriate currency 19 20 21 22
Gamez Maravilla_Chapter_2-1_Currency_Start (2) AutoSave OFF A A Calibri (Body) Wrap Text v General 16 LE Paste Cell Styles В I Conditional Format Formatting as Table $ Inse Merge & Center U v 00 0 fx Currency A1 A C D G Н К L м N P R Currency 1 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, as you will not receive full credit for your answers 2 3 Ratio of Currencies Dollars 3.00 4 Assume the ratio of euros to dollars to yen is 3 4:500. Euros Yen $4.00 5 Y500.00 6 7 8 Input Input Input Euros 200.00 Yen: X4,000.00 € 60.00 9 Dollars: 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. а.) а.) а.) 10 Outputs Outputs Outputs 11 12 Euros: Dollars Euros: Dollars 13 Yen: Yen: 14 b.) b.) ARS 15 GBP USD 16 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 $1.00 17 18 the appropriate ratios on the sheet assuming you start with 1 USD. Format as appropriate currency 19 20 21 22
Elementary Algebra
17th Edition
ISBN:9780998625713
Author:Lynn Marecek, MaryAnne Anthony-Smith
Publisher:Lynn Marecek, MaryAnne Anthony-Smith
Chapter2: Solving Linear Equations And Inequalities
Section: Chapter Questions
Problem 630RE: Describe how you have used two topics from this chapter in your life outside of your math class...
Related questions
Question
i need the formulas for the excel sheet
![Gamez Maravilla_Chapter_2-1_Currency_Start (2)
AutoSave
OFF
A A
Calibri (Body)
Wrap Text v
General
16
LE
Paste
Cell
Styles
В I
Conditional Format
Formatting as Table
$
Inse
Merge & Center
U v
00
0
fx Currency
A1
A
C
D
G
Н
К
L
м
N
P
R
Currency
1
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, as you will not receive full credit for your answers
2
3
Ratio of Currencies
Dollars
3.00
4
Assume the ratio of euros to dollars to yen is 3 4:500.
Euros
Yen
$4.00
5
Y500.00
6
7
8 Input
Input
Input
Euros
200.00
Yen:
X4,000.00
€ 60.00
9 Dollars:
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.
а.)
а.)
а.)
10
Outputs
Outputs
Outputs
11
12 Euros:
Dollars
Euros:
Dollars
13 Yen:
Yen:
14
b.)
b.)
ARS
15
GBP
USD
16
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
$1.00
17
18
the appropriate ratios on the sheet assuming you start with 1 USD. Format as
appropriate currency
19
20
21
22](/v2/_next/image?url=https%3A%2F%2Fcontent.bartleby.com%2Fqna-images%2Fquestion%2Fb44c21e2-9f26-4a75-9b48-a9ed151b3868%2Fe86cb316-c6c6-409a-89cc-44d6b2630a86%2Fexoo8x4.png&w=3840&q=75)
Transcribed Image Text:Gamez Maravilla_Chapter_2-1_Currency_Start (2)
AutoSave
OFF
A A
Calibri (Body)
Wrap Text v
General
16
LE
Paste
Cell
Styles
В I
Conditional Format
Formatting as Table
$
Inse
Merge & Center
U v
00
0
fx Currency
A1
A
C
D
G
Н
К
L
м
N
P
R
Currency
1
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, as you will not receive full credit for your answers
2
3
Ratio of Currencies
Dollars
3.00
4
Assume the ratio of euros to dollars to yen is 3 4:500.
Euros
Yen
$4.00
5
Y500.00
6
7
8 Input
Input
Input
Euros
200.00
Yen:
X4,000.00
€ 60.00
9 Dollars:
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.
а.)
а.)
а.)
10
Outputs
Outputs
Outputs
11
12 Euros:
Dollars
Euros:
Dollars
13 Yen:
Yen:
14
b.)
b.)
ARS
15
GBP
USD
16
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
$1.00
17
18
the appropriate ratios on the sheet assuming you start with 1 USD. Format as
appropriate currency
19
20
21
22
Expert Solution
![](/static/compass_v2/shared-icons/check-mark.png)
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
This is a popular solution!
Trending now
This is a popular solution!
Step by step
Solved in 3 steps with 1 images
![Blurred answer](/static/compass_v2/solution-images/blurred-answer.jpg)
Knowledge Booster
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, advanced-math and related others by exploring similar questions and additional content below.Recommended textbooks for you
![Elementary Algebra](https://www.bartleby.com/isbn_cover_images/9780998625713/9780998625713_smallCoverImage.jpg)
Elementary Algebra
Algebra
ISBN:
9780998625713
Author:
Lynn Marecek, MaryAnne Anthony-Smith
Publisher:
OpenStax - Rice University
![Algebra: Structure And Method, Book 1](https://www.bartleby.com/isbn_cover_images/9780395977224/9780395977224_smallCoverImage.gif)
Algebra: Structure And Method, Book 1
Algebra
ISBN:
9780395977224
Author:
Richard G. Brown, Mary P. Dolciani, Robert H. Sorgenfrey, William L. Cole
Publisher:
McDougal Littell
![Elementary Algebra](https://www.bartleby.com/isbn_cover_images/9780998625713/9780998625713_smallCoverImage.jpg)
Elementary Algebra
Algebra
ISBN:
9780998625713
Author:
Lynn Marecek, MaryAnne Anthony-Smith
Publisher:
OpenStax - Rice University
![Algebra: Structure And Method, Book 1](https://www.bartleby.com/isbn_cover_images/9780395977224/9780395977224_smallCoverImage.gif)
Algebra: Structure And Method, Book 1
Algebra
ISBN:
9780395977224
Author:
Richard G. Brown, Mary P. Dolciani, Robert H. Sorgenfrey, William L. Cole
Publisher:
McDougal Littell