AmbitionBox
Interview Questions
- Reviews
- Salaries
- Interview Questions
- About Company
- Benefits
- Jobs
- Office Photos
- Community
Add office photos
i
L&T Finance
Compare
Filter interviews by
L&T Finance MIS Executive Interview Questions and Answers for Experienced
L&T Finance MIS Executive Interview Experiences for Experienced
1 interview found
Saquib Jawed
(2 Questions)
- Q1. About Excel like VLOOKUP index match pivot table
- Q2. Communication is not important you attitude is matter
Top trending discussions
Interview questions from similar companies
Selected
I applied via Referal and was interviewed before Dec 2021. There were 2 interview rounds.
(5 Questions)
- Q1. It was about customer service and need to know multilingual languages was asked about to speak about my family in Hindi and talk on the recent movie I watched .. it was cool and easy
- Q2. Why would you like to join the company
- Ans.
I would like to join the company because of its strong reputation, opportunities for growth, and alignment with my career goals.
The company has a strong reputation in the industry, which is appealing to me as it indicates stability and success.
I believe that the company offers great opportunities for growth and development, which is important to me as I am looking to advance my career.
The company's values and mission a...
- Q3. How come you knew abt the openings
- Ans.
I regularly keep myself updated about job openings through various sources.
I actively search for job openings on job portals and company websites.
I network with professionals in my field who may inform me about job opportunities.
I subscribe to email alerts and newsletters from job search platforms.
I follow social media pages and groups related to job postings.
I attend career fairs and industry events where companies of
- Q4. How can you deal with a frustrated client
- Ans.
To deal with a frustrated client, it is important to remain calm, empathize with their concerns, actively listen, offer solutions, and follow up to ensure satisfaction.
Stay calm and composed
Empathize with the client's frustrations
Listen actively and attentively to their concerns
Offer solutions or alternatives to address their issues
Follow up to ensure their satisfaction
Maintain a professional and positive attitude thro
- Q5. No questions asked further winded
Interview Preparation Tips
Anonymous
(2 Questions)
- Q1. Reportings applicable to function
- Ans.
Reportings are essential for any function to track progress and identify areas of improvement.
Regular reports should be generated to track progress and identify areas of improvement.
Reports should be customized to the specific function and its goals.
Reports should be easily understandable and actionable.
Examples of reportings applicable to functions include sales reports, performance reports, and budget reports.
- Q2. Regulatory updates going on business environment
- Ans.
Regulatory updates are constantly shaping the business environment, impacting industries and companies in various ways.
Regulations can affect everything from product development to marketing and sales strategies
Changes in regulations can create new opportunities or pose challenges for businesses
Industries such as healthcare, finance, and technology are particularly affected by regulatory updates
Examples of recent regul...
Interview Preparation Tips
manish mahala
I applied via Company Website and was interviewed in Feb 2024. There were 2 interview rounds.
Reasoning , SQL and probability
(2 Questions)
- Q1. SQL queries and python
- Q2. Reasoning and guesstimate
I applied via Walk-in and was interviewed in Apr 2024. There was 1 interview round.
An Excel file was given which had 2 sheets, sheet1 with raw data and sheet2 with task. There were 5-6 questions in Task. This tasks can be done by formulas such as CONCAT, Textjoin, Age calculation using Datedif, Vlookup, age band creation eg: 10-30,30-40 based on age I used nested IF, PIVOT Table
Interview Preparation Tips
- Advanced Excel
I applied via Naukri.com and was interviewed in Jul 2021. There were 3 interview rounds.
Interview Questionnaire
4 Questions
- Q1. What is the V-lookup formula?
- Ans.
VLOOKUP is a function in Excel that allows you to search for a value in a column and return a corresponding value from another column.
VLOOKUP stands for vertical lookup.
It is commonly used to find specific data in large datasets.
The formula takes four arguments: lookup value, table array, column index number, and range lookup.
Example: =VLOOKUP(A2, B2:D10, 3, FALSE) will search for the value in cell A2 in the range B2:D...
- Q2. What is the use of pivot table?
- Ans.
A pivot table is a data summarization tool used in spreadsheet programs to organize and analyze large amounts of data.
Pivot tables allow users to quickly summarize and analyze data from different perspectives.
They can be used to group and aggregate data based on different criteria.
Pivot tables provide flexibility in rearranging and reorganizing data to gain insights.
They help in identifying patterns, trends, and outlie...
- Q3. How to remove duplicate value?
- Ans.
Duplicate values can be removed using various methods.
Use a hashset to store unique values and remove duplicates
Sort the array and remove adjacent duplicates
Use a loop to compare each element with all other elements and remove duplicates
Use the distinct() method in LINQ for C#
Use the set() method in Python
- Q4. How to use if formula?
- Ans.
IF formula is used to test a condition and return a value based on the result.
Syntax: =IF(condition, value_if_true, value_if_false)
Example: =IF(A1>10, "Yes", "No")
Nested IF statements can be used for multiple conditions.
Skills evaluated in this interview
(2 Questions)
- Q1. What about you?
- Q2. What's experiance do you have?
- Ans.
I have 5 years of experience in managing and analyzing data for various projects.
Managed databases and data systems for efficient data retrieval and analysis
Developed reports and dashboards to track key performance indicators
Implemented data quality processes to ensure accuracy and consistency
Collaborated with cross-functional teams to identify and address data-related issues
Excel formulas and practical this formulas
Interview Preparation Tips
Selected
I applied via Referral and was interviewed in Jun 2024. There was 1 interview round.
(1 Question)
- Q1. What are your reasons for wanting to switch jobs?
- Ans.
I am seeking new challenges and opportunities for growth in my career.
Looking for a more challenging role to further develop my skills
Seeking opportunities for career advancement
Interested in working in a different industry to broaden my experience
I applied via Naukri.com and was interviewed in Jun 2021. There were 3 interview rounds.
Interview Questionnaire
1 Question
- Q1. Techical skill
Interview Preparation Tips
I applied via Naukri.com
(1 Question)
- Q1. MSO365, Outlook, zscaler, McAfee DLP, Encryption, bit locker encryption, end user support, hardware and software installation & Support, Technical issue resolved by quickly, Asset management, camera knowle...
(1 Question)
- Q1. Customer support and manage the remote user and resolve issue quickly
Interview Preparation Tips
L&T Finance Interview FAQs
Tell us how to improve this page.
L&T Finance Interviews By Designations
- L&T Finance Sales Officer Interview Questions
- L&T Finance Frontline Officer Interview Questions
- L&T Finance Collection Officer Interview Questions
- L&T Finance Area Collection Manager Interview Questions
- L&T Finance Sales Executive Interview Questions
- L&T Finance Collections Manager Interview Questions
- L&T Finance Branch Manager Interview Questions
- L&T Finance Senior Manager Interview Questions
- Show more
Interview Questions for Popular Designations
- Senior MIS Executive Interview Questions
- MIS Executive and Analyst Interview Questions
- MIS Executive and Coordinator Interview Questions
- MIS and Back Office Executive Interview Questions
- Executive Interview Questions
- Sales Executive Interview Questions
- Senior Executive Interview Questions
- Accounts and MIS Executive Interview Questions
- Show more
L&T Finance MIS Executive Interview Process for Experienced
based on 1 interview
Interview experience
MIS Executive Interview Questions from Similar Companies
Fast track your campus placements
L&T Finance MIS Executive Reviews and Ratings
based on 1 review
Rating in categories
|
Senior Manager
390
salaries
|  ₹8.1 L/yr - ₹26 L/yr |
|
Manager
363
salaries
| ₹5 L/yr - ₹17 L/yr |
|
Assistant Manager
296
salaries
| ₹2.2 L/yr - ₹8.8 L/yr |
|
Collection Officer
283
salaries
| ₹1.2 L/yr - ₹3.8 L/yr |
|
Business Manager
249
salaries
| ₹3.3 L/yr - ₹9 L/yr |
Shriram Finance
Muthoot Fincorp
IIFL Finance
Muthoot Finance
- Home >
- Interviews >
- L&T Finance Interview Questions >
- L&T Finance MIS Executive Interview Questions for Experienced
