Question 1: Develop and document a model that allows the user to query exchange rates across three or more currencies. Prepare a spread sheet that stores a table of exchange rate across three or more currencies that the user can fill in before the program runs.
For example to illustrate you could use the following rates:
1 GBP = 1.12952 EUR; 1 EUR = 0.885329 GBP
1 GBP = 1.64004 USD; 1 USD = 0.609740 GBP
1 USD = 0.688735 EUR; 1 EUR = 1.45194 USD
At any run time the user simply sates the source and destination currencies and your model should output to the screen the relevant exchange rate picked out from the table. (In other words create an efficient multicurrency conventor)
5 pages report with excel multicurrency conventor
Question 2:(i) Create a workbook with a macro that creates three additional excel windows from the same workbook. Explain how your VBA macro works
(ii) Create a workbook containing a macro with VBA code that finds the average of a range of numbers. Discuss how your macro functions.
Please give me the solutions with a 5 page report
Dear client,
I have sound knowledge in Excel and I have previously carried out a number of projects in excel using macros and formulas. I ensure you will be happy after hiring me.
Kindly contact me for further details.
Thanks and regards
Roy