Exl India Analyst Interview Questions and Answers

Sixty questions, sixty minutes

Q1. Excel,Macros,Vllookup
Add your answer

Q1. Vlookup, index match,
Add your answer

Q1. Asked very basic questions of sql any one who has experience of 1 year should be able to do that
Add your answer

Q1. It majorly based on basic sql and Python with some guesstimates.
Add your answer

It was based on a real life logistics scenario and then solving the case study.

Q1. What is the order of execution for SQL queries?
Ans. 
SQL queries execute in a specific order, determining how data is retrieved and manipulated.
• 1. FROM clause: Specifies the tables to retrieve data from. Example: SELECT * FROM employees.

• 2. JOIN clause: Combines rows from two or more tables based on a related column. Example: SELECT * FROM employees JOIN departments ON employees.dept_id = departments.id.

• 3. WHERE clause: Filters records based on specified conditions. Examp...read more
Answered by AI
Add your answer
Q2. Write SQL query for the question which required knowledge of the LEAD and LAG functions for its solution.
Ans. 
Using LEAD and LAG functions to analyze sequential data in SQL queries.
• LEAD() retrieves the next row's value in a specified column.

• LAG() retrieves the previous row's value in a specified column.

• Example: SELECT value, LAG(value) OVER (ORDER BY date) AS previous_value FROM sales;

• Example: SELECT value, LEAD(value) OVER (ORDER BY date) AS next_value FROM sales;

• Useful for comparing current row data with previous or next row...read more
Answered by AI
Add your answer
Q3. Puzzle kind of question
Add your answer
Q4. Asked about the past project and discussed about it.
Add your answer

Q1. What is your experience with accounting?
Ans. 
I have 5 years of experience in accounting, including financial statement preparation and analysis.
• 5 years of experience in accounting

• Proficient in financial statement preparation

• Skilled in financial analysis
Answered by AI
Add your answer
Q2. Journal entries
Add your answer