GoMechanic Interview Questions and Answers

Q1. What is Vlookup and Hlookup
Ans. 
Vlookup and Hlookup are Excel functions used to search for a value in a table and return a corresponding value.
• Vlookup searches for a value in the first column of a table and returns a value in the same row from a specified column.

• Hlookup searches for a value in the first row of a table and returns a value in the same column from a specified row.

• Both functions are commonly used in Excel for data analysis and lookup ope
Answered by AI
Add your answer

Q1. Brief introduction
Add your answer
Q2. What is your strength and weakness
Ans. 
Strength: Strong analytical skills, Weakness: Difficulty delegating tasks
• Strength: Ability to analyze complex financial data and make strategic decisions

• Strength: Strong attention to detail and accuracy in financial reporting

• Weakness: Struggle with delegating tasks and trusting others to complete them

• Weakness: Tendency to take on too much work and become overwhelmed
Answered by AI
Add your answer

Q1. What is Working capital
Ans. 
Working capital is the difference between current assets and current liabilities, representing the funds available for day-to-day operations.
• Working capital is calculated by subtracting current liabilities from current assets.

• It represents the liquidity available to a company for its daily operations.

• Positive working capital indicates that a company has enough assets to cover its short-term liabilities.

• Negative working...read more
Answered by AI
Add your answer
Q2. Golden rule of accounting
Ans. 
The golden rule of accounting states that debit what comes in and credit what goes out.
• Debit what comes in and credit what goes out

• Assets = Liabilities + Equity

• Helps maintain the balance in financial statements
Answered by AI
Add your answer

Q1. Have you conducted IPO
Ans. 
Yes, I have conducted IPOs for multiple companies in my previous role as Assistant Company Secretary.
• Led the IPO process from start to finish, including drafting prospectuses and coordinating with legal and financial teams

• Ensured compliance with regulatory requirements and stock exchange rules

• Managed investor relations and communications during the IPO process

• Examples: Successfully conducted IPOs for Company X and Comp
Answered by AI
Add your answer

General SQL and Python questions for Data analysis and Visualization tools

Q1. What do you understand y Churn Rate ?
Ans. 
Churn Rate is the percentage of customers who stop using a product or service over a certain period of time.
• Churn Rate is calculated by dividing the number of customers who stopped using the product by the total number of customers at the beginning of the period.

• It is used to measure customer retention and satisfaction.

• A high churn rate indicates that a company may be losing customers at a high rate, while a low churn ...read more
Answered by AI
Add your answer
Q2. What can be done to increase retention rate ?
Ans. 
To increase retention rate, companies can focus on improving employee engagement, providing opportunities for growth and development, offering competitive compensation and benefits, and creating a positive work culture.
• Improve employee engagement through regular feedback sessions and recognition programs

• Provide opportunities for growth and development through training programs and career advancement opportunities

• Offer ...read more
Answered by AI
Add your answer

Q1. Previous experience?
Add your answer
Q2. Why you left last company?
Add your answer
Q3. Your roles and responsibilities?
Add your answer

Q1. In depth understanding why you left last organization?
Add your answer
Q2. Why you want to join GoMechanic?
Add your answer
Q3. Your roles and responsibilities in last company?
Add your answer
Q4. What new you will bring by joining in as TL?
Add your answer
Q5. What changes you will make in the process by joining in?
Add your answer

Q1. Tell me about yourself
Add your answer