Introduction to Money and Financial Systems

The fundamentals of money, financial systems, and the role of banks include:

• Currency, banking, and investment

• Trade, barter, and exchange

• Loans, interest, and credit

• All of the above

What Excel techniques can be learned using financial data, including formulas, charts, and data formatting?

• Data analysis techniques

• Excel techniques using financial data

• Basic Excel skills

• Advanced Excel programming

Which of the following are basic Excel formulas?

• SUM, AVERAGE, MIN, MAX

• SUMIF, COUNTIF, VLOOKUP

• INDEX, MATCH, IFERROR

• All of the above

Excel can be used as a financial tool in which of the following ways?

• Budgeting and forecasting

• Creating presentations

• Designing websites

• Editing videos

How would you set up a currency conversion tool to convert between different currencies and display historical exchange rates?

• By using an API to fetch real-time and historical exchange rates

• By manually updating exchange rates daily

• By using a fixed exchange rate for all conversions

• By converting currencies using a calculator

What is the formula to calculate the converted amount for the currency pair USD/GBP?

• Amount in USD * Exchange Rate

• Amount in USD / Exchange Rate

• Amount in GBP * Exchange Rate

• Amount in GBP / Exchange Rate

Which of the following formulas is used to calculate the converted amount for EUR/USD?

• =B2*C2

• =B3*C3

• =B4*C4

• =B5*C5

Fill in the blank: The formula to calculate the converted amount for GBP/EUR is ________.

What is the formula to calculate the converted amount for USD/EUR?

• Exchange Rate * USD Amount

• USD Amount / Exchange Rate

• (USD Amount + Exchange Rate) / 2

• Exchange Rate - USD Amount

Fill in the blank: The exchange rate for the currency pair USD/GBP is ____.

• 1.30

• 1.25

• 1.35

• 1.40