Gamez Maravilla_Chapter_2-1_Currency_Start (2)AutoSaveOFFA ACalibri (Body)Wrap Text vGeneral16LEPasteCellStylesВ IConditional FormatFormatting as Table$InseMerge & CenterU v000fx CurrencyA1ACDGНКLмNPRCurrency1Use 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 answers23Ratio of CurrenciesDollars3.004Assume the ratio of euros to dollars to yen is 3 4:500.EurosYen$4.005Y500.00678 InputInputInputEuros200.00Yen:X4,000.00€ 60.009 Dollars:a.) Given an input of any amount of one currency, enter formulas that outputthe proportional amount of the other two currencies. Use the ratios ofcurrencies in cells B6:D6 in your formulas. Format as appropriate currency.а.)а.)а.)10OutputsOutputsOutputs1112 Euros:DollarsEuros:Dollars13 Yen:Yen:14b.)b.)ARS15GBPUSD16b.) 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.001718the appropriate ratios on the sheet assuming you start with 1 USD. Format asappropriate currency19202122

Question
Asked Oct 5, 2019

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
help_outline

Image Transcriptionclose

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

fullscreen
check_circle

Expert Answer

Step 1

This is an exercise for converting currencies using Excel

Step 2

Insert the conversion rates in B6, D6 , E6 as given. Insert the inputs in ...

D6 B10/B6
D6 C10/C6
C6*B10/B6
help_outline

Image Transcriptionclose

D6 B10/B6 D6 C10/C6 C6*B10/B6

fullscreen

Want to see the full answer?

See Solution

Check out a sample Q&A here.

Want to see this answer and more?

Solutions are written by subject experts who are available 24/7. Questions are typically answered within 1 hour.*

See Solution
*Response times may vary by subject and question.
Tagged in

Math

Advanced Math

Related Advanced Math Q&A

Find answers to questions asked by student like you

Show more Q&A add
question_answer

Q: Please provide explanation as to how the end result was obtained. Please be as explicit as possible....

A: Use the matrix multiplication rule. According to this rule, the number of column of the 1st matrix m...

question_answer

Q: A company manufactures Products A, B, and C. Each product is processed in three departments: I, II, ...

A: Let the company produce x1 , x2  and  x3 units of product A, B and C in order to maximize the profit...

question_answer

Q: 2

A: According to the given information:

question_answer

Q: Suppose you saw a sign at your local bank that​ said, "5.4% rate compounded semiannually-5.9% Annual...

A: Given that :

question_answer

Q: Assume that the store stocks 30 percent brand A, 50 percent brand B, and the rest are brand X. Assum...

A: According to the given information:The store stocks 30% brand A in which 15%  does not provide the n...

question_answer

Q: 1. Given a line P(t) through the points Po = [1,0|7 and P [2,4]7 in 2D (a) Extend P(t) to homogeneou...

A: The problem is concerned with projective plane , line and homogeneous coordinates

question_answer

Q: The product of three integers is −2. Determine all of the possible values for the three factors. Wri...

A: Let x, y and z be the three factors of the product –2.The possible values for the three factors are ...

question_answer

Q: Find the general solution of the given differential equation. x2(dy/dx) + x(x+2)y = ex Determine whe...

A: The differential equation is x2(dy/dx) + x ( x + 2) y =ex.

question_answer

Q: Pharmacy Calculations- what is the daily supply Amoxicillin 125mg/5ml  100 ml SIG: ii tsp tid  I got...

A: To choose the correct whole number between 13 and 14 , in the given context