Suppose one us dollar can be converted to euros, mexican pesos, or yens. the portfolio file contains a list of customers that need dollars to be converted to one of the three below currencies at the respective rates indicated. use excel formulas and functions as appropriate.
a) using the vlookup function for each customer, display the unit value and total value in the converted currency. in particular, how many euros will customer nancy have?
b) use the countif function to determine how many customers have a need to convert to euro currency?
c) use the sumif function to determine the total mexican peso currency necessary to cover the conversions from dollars.
currency conversion
symbol rate
usd 1
euros 0.84
pesos 19.11
yen 109.65
customer # name dollars to? unit value total value
alan 15.00 pesos
11223344 barry 20.00 euros
11335577 corry 100.00 yen
11447810 diane 50.00 pesos
11560043 evan 75.00 euros
11672276 frank 200.00 euros
11784509 harry 5.00 pesos
11896742 ivan 30.00 pesos
12008975 jack 500.00 yen
12121208 kevin 22.00 yen
12233441 larry 10.00 euros
12345674 mary 37.00 yen
12457907 nancy 540.00 euros
12570140 orren 35.00 euros
12682373 paul 45.00 yen
12794606 robert 300.00 yen
12906839 steve 60.00 pesos
13019072 tom 150.00 euros
13131305 uri 30.00 pesos
13243538 victor 200.00 yen

step-by-step explanation: the declaration of the rights of man and of the citizen (french: déclaration des droits de l'homme et du citoyen de 1789), set by france's national constituent assembly in 1789, is a human civil rights document from the french revolution.[1]

the declaration was drafted by the abbé sieyès and the marquis de lafayette, in consultation with thomas jefferson.[2] influenced by the doctrine of "natural right", the rights of man are held to be universal: valid at all times and in every place, pertaining to human nature itself. it became the basis for a nation of free individuals protected equally by the law. it is included in the beginning of the constitutions of both the fourth french republic (1946) and fifth republic (1958) and is still current. inspired by the enlightenment philosophers, the declaration was a core statement of the values of the french revolution and had a major impact on the development of freedom and democracy in europe and worldwide.[3]

the 1789 declaration, together with the 1215 magna carta, the 1689 english bill of rights (1689), the 1776 united states declaration of independence, and the 1789 united states bill of rights, inspired in large part the 1948 united nations universal declaration of human rights

8/k

step-by-step explanation:

i dont understand

step-by-step explanation:

jfkc

step-by-step explanation:

jhcxzbfzc