10+ Universiti Teknologi Petronas Interview Questions and Answers

Reverse Repo Rate and Repo Rate are monetary policy tools used by Reserve Bank of India to control inflation and liquidity in the economy.

• Repo Rate is the rate at which RBI lends money to commercial banks in case of shortage of funds.

• Reverse Repo Rate is the rate at which RBI borrows money from commercial banks.

• Both rates are used to control inflation and liquidity in the economy.

• If RBI wants to increase liquidity, it reduces Repo Rate and if it wants to decrease liquidity, i...read more

Financial system is a network of institutions, markets, and intermediaries that facilitate the flow of funds between savers and borrowers.

• Regulatory bodies include SEC, FDIC, CFTC, OCC, and Federal Reserve

• SEC regulates securities markets and protects investors

• FDIC insures deposits in banks and savings associations

• CFTC regulates futures and options markets

• OCC supervises and regulates national banks

• Federal Reserve regulates monetary policy and oversees the banking system

Pivot Table is a data summarization tool in MS Excel.

• It allows users to quickly summarize and analyze large amounts of data.

• Users can easily group and filter data based on different criteria.

• Pivot Tables can be used to create charts and graphs for visual representation of data.

• Example: A sales report can be summarized by product, region, and time period using Pivot Table.

• Example: A survey data can be analyzed by age group, gender, and location using Pivot Table.

H-Lookup and V-Lookup are functions in MS Excel used to search for specific data in a table.

• H-Lookup searches for data in a horizontal row and returns a corresponding value from a specified column.

• V-Lookup searches for data in a vertical column and returns a corresponding value from a specified row.

• Both functions require a reference table and a lookup value.

• They are commonly used in data analysis and management.

• Example: H-Lookup can be used to find the price of a specific ite...read more

Insurance is a contract between an individual and an insurance company to protect against financial loss.

• Insurance provides financial protection against unexpected events such as accidents, illnesses, and natural disasters.

• It helps individuals and businesses manage risk by transferring the risk to the insurance company.

• Insurance also provides peace of mind and can help individuals and businesses recover from financial losses.

• Examples of insurance include health insurance, car...read more

Determining the value of insurance for an individual

• Consider the individual's financial obligations and responsibilities

• Evaluate the individual's income and assets

• Assess the individual's risk tolerance and desired level of coverage

• Take into account the individual's age, health condition, and dependents

• Consider the potential costs of medical treatments, property damage, or liability claims

• Consult with insurance professionals or use online calculators for guidance

I would suggest a life insurance policy with a critical illness rider.

• A life insurance policy will provide financial security to the dependents in case of the policyholder's untimely demise.

• A critical illness rider will provide coverage for major illnesses like cancer, heart attack, etc.

• The policy should have a sufficient sum assured to cover the family's expenses and future needs.

• The premium should be affordable and the policy should have flexible payment options.

• The policyh...read more

Macro is a set of instructions that automate repetitive tasks in MS Word.

• Macros can be recorded or written in Visual Basic for Applications (VBA)

• They can be assigned to a button or keyboard shortcut for easy access

• Examples of tasks that can be automated with macros include formatting, inserting text, and running spell check

• Macros can save time and increase productivity for users who frequently perform the same tasks in Word

Endowment policy provides both insurance and savings, while term insurance only provides insurance coverage.

• Endowment policy pays out a lump sum at the end of the policy term, while term insurance pays out only in case of death during the policy term.

• Endowment policy premiums are higher than term insurance premiums due to the savings component.

• Endowment policy is suitable for those who want both insurance and savings, while term insurance is suitable for those who only want i...read more

FV stands for Future Value and PV stands for Present Value.

• FV is the value of an asset or investment at a specified date in the future, based on the expected growth rate.

• PV is the current value of a future sum of money or stream of cash flows, discounted at a specific rate.

• FV and PV are commonly used in finance and accounting to calculate the value of investments, loans, and annuities.

• For example, if you invest $100 today at a 5% annual interest rate, the FV after one year wo...read more