Team Lease MIS Executive Interview Questions and Answers

Q1. Index and match function in Excel and joins & diff Where and group & Diff delete and truck in SQL.
Ans. 
Index and match functions in Excel are used to lookup values in a table, while joins and diffs in SQL are used to combine and compare data from different tables.
• Index and match functions in Excel are used to search for a value in a table based on row and column headers.

• Joins in SQL are used to combine data from two or more tables based on a related column between them.

• Diffs in SQL are used to compare data between two t...read more
Answered by AI
Add your answer
Q2. Scenario based quetions
Add your answer

Q1. Scenario based questions
Add your answer

Q1. Salary discussion
Add your answer

Q1. Introduction background job related questions
Add your answer
Q2. Advance Excel formula?
Ans. 
Advance Excel formula includes VLOOKUP, INDEX-MATCH, SUMIF, COUNTIF, IFERROR, CONCATENATE, and more.
• VLOOKUP - used to search for a specific value in a table and return a corresponding value

• INDEX-MATCH - used to search for a specific value in a table and return a corresponding value, but more flexible than VLOOKUP

• SUMIF - used to sum values in a range that meet a specific criteria

• COUNTIF - used to count the number of cel...read more
Answered by AI
Add your answer

Any topic on current affairs

Q1. Previous experience in detail
Ans. 
I have 3 years of experience as an MIS Executive and Analyst in a multinational company.
• Managed and analyzed data to provide insights for decision-making

• Created reports and dashboards using Excel and BI tools

• Collaborated with cross-functional teams to improve data accuracy and efficiency
Answered by AI
Add your answer
Q2. How do you think you are a good fit for the role?
Add your answer

Q1. Client will ask about the tool we know or about our technical proficiency to know if we are good fit for the role
Add your answer
Q2. Previous company experience and ms office experience
Add your answer

Q1. There will be a scenario and we need to write a code to run that also
Add your answer

Q1. Salary discussion
Add your answer
Q2. Documentation in the last
Ans. 
Documentation is crucial for maintaining accurate records and ensuring smooth operations.
• Documentation helps in tracking changes and updates in systems and processes.

• It provides a reference point for troubleshooting and resolving issues.

• Proper documentation ensures consistency and standardization in operations.

• Examples include user manuals, system configurations, process flowcharts, and troubleshooting guides.
Answered by AI
Add your answer

Q1. Self introduction And other questions
Add your answer

Q1. What is the account s payable What is the golden rules
Ans. 
Accounts payable is the amount of money a company owes to its suppliers or vendors for goods or services purchased on credit.
• Accounts payable is a liability on the balance sheet representing the amount a company owes for goods or services purchased on credit.

• The golden rules of accounts payable include ensuring accurate and timely recording of invoices, maintaining good relationships with suppliers, and managing cash f...read more
Answered by AI
Add your answer

Q1. General introduction about yourself
Add your answer

Q1. Subject knowldge
Add your answer

Q1. Final round with CFO
Add your answer

Q1. Questions related to advance Excel lookup
Add your answer
Q2. Previous job in details
Ans. 
Worked as a MIS Executive at XYZ Company, responsible for data analysis and reporting.
• Managed and analyzed data to generate reports for management decision-making

• Developed and maintained databases to track key performance indicators

• Collaborated with different departments to gather data and ensure accuracy

• Utilized Excel, SQL, and other tools for data manipulation and visualization
Answered by AI
Add your answer

Q1. Transport handle vehicle sorusing team work. Responsibility our work
Add your answer