10+ Interview Questions and Answers

VLOOKUP has limitations such as only searching for values in the leftmost column and being case-sensitive.

• VLOOKUP only searches for values in the leftmost column of a table

• It is case-sensitive, so if the lookup value has a different case than the table, it won't find a match

• It can only return one value, so if there are multiple matches, it will only return the first one

• It can be slow and resource-intensive for large datasets

Capital markets are financial markets where long-term securities such as stocks and bonds are traded.

• Capital markets are where companies and governments raise funds by issuing securities.

• These markets are typically for long-term investments and have a lower liquidity than other financial markets.

• Examples of capital markets include the New York Stock Exchange and the bond market.

• Investors in capital markets are typically institutional investors such as pension funds and insura...read more

Financial instruments are assets that can be traded, such as stocks, bonds, and derivatives.

• Financial instruments are used to raise capital and manage risk

• They can be categorized as debt, equity, or derivative instruments

• Examples include stocks, bonds, options, futures, and swaps

A mutual fund is a type of investment vehicle made up of a pool of money collected from many investors to invest in securities.

• Mutual funds are managed by professional fund managers

• Investors buy shares in the mutual fund and the value of their investment is determined by the performance of the underlying securities

• Mutual funds offer diversification and convenience for investors

• Examples of mutual fund companies include Vanguard, Fidelity, and BlackRock

The 10 UST is located in the United States Treasury.

• The 10 UST refers to a 10-year U.S. Treasury bond.

• It is a commonly used benchmark for interest rates and economic indicators.

• Investors often track the yield on the 10 UST as an indicator of market sentiment.

Find the range with maximum sum in an array of strings

• Iterate through the array and calculate the sum of each range

• Keep track of the maximum sum and corresponding range

• Return the range with maximum sum

Mutual funds can be categorized into various types based on their investment objective, asset class, and structure.

• Equity funds invest in stocks of companies

• Debt funds invest in fixed income securities like bonds and treasury bills

• Hybrid funds invest in a mix of equity and debt instruments

• Index funds track a specific market index

• Sector funds invest in a specific sector like technology or healthcare

• Tax-saving funds offer tax benefits under Section 80C of the Income Tax Act

• Open...read more

Human Resources is a department within an organization responsible for managing employee relations, recruitment, training, and benefits.

• Responsible for recruitment and hiring processes

• Handles employee relations and conflict resolution

• Manages employee benefits and compensation

• Provides training and development opportunities

• Ensures compliance with labor laws and regulations

Balance sheet shows a company's financial position at a specific point in time, including assets, liabilities, and equity.

• Balance sheet is a snapshot of a company's financial health at a specific date

• It includes assets (what the company owns), liabilities (what the company owes), and equity (the difference between assets and liabilities)

• Assets are typically listed in order of liquidity, liabilities in order of due date

• Balance sheet equation: Assets = Liabilities + Equity

A balance sheet of a bank shows its assets, liabilities, and shareholders' equity at a specific point in time.

• Assets include cash, loans, investments, and property owned by the bank.

• Liabilities consist of deposits, borrowings, and other obligations the bank owes to external parties.

• Shareholders' equity represents the amount of capital contributed by shareholders and retained earnings.

• The balance sheet equation is Assets = Liabilities + Shareholders' Equity.

• Example: Bank XYZ's...read more