Kotak Securities Assistant Manager Interview Questions, Process, and Tips for Freshers

I have advanced Excel skills including VLOOKUP, pivot tables, and macros.

• Proficient in VLOOKUP function for data lookup

• Experience creating and analyzing pivot tables for data summarization

• Knowledge of recording and running macros for automation

• Familiar with advanced functions like INDEX-MATCH and conditional formatting

I analyse a stock by researching its financial statements, industry trends, and management team.

• Research financial statements to understand revenue, expenses, and profitability

• Analyze industry trends to determine growth potential and competition

• Evaluate management team to assess their track record and leadership skills

• Consider external factors such as economic conditions and regulatory environment

• Use valuation metrics ...read more

The stock market is a platform where investors buy and sell shares of publicly traded companies.

• Stock market allows companies to raise capital by selling shares to investors

• Investors can buy and sell shares to potentially earn profits

• Stock prices are influenced by various factors such as company performance, economic conditions, and market trends

A demat account is an account that holds shares and securities in electronic form.

• Demat account stands for dematerialized account

• It is used to hold securities like stocks, bonds, and mutual funds in electronic form

• It eliminates the need for physical share certificates

• Transactions in demat account are done electronically

• Investors can access their demat account online to track their holdings and transactions