Upload Button Icon Add office photos
Engaged Employer

i

This company page is being actively managed by Home Credit Finance Team. If you also belong to the team, you can get access from here

Home Credit Finance Verified Tick

Compare button icon Compare button icon Compare

Filter interviews by

Clear (1)

Home Credit Finance MIS Executive Interview Questions and Answers

Updated 20 Apr 2024

Home Credit Finance MIS Executive Interview Experiences

2 interviews found

MIS Executive Interview Questions & Answers

user image Anonymous

posted on 20 Apr 2024

Interview experience
4
Good
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Selected Selected

I applied via WorkIndia and was interviewed in Oct 2023. There was 1 interview round.

Round 1 - Group Discussion 

Present Working & Personal Information

MIS Executive Interview Questions & Answers

user image Anonymous

posted on 24 Oct 2023

Interview experience
4
Good
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Selected Selected

I applied via Referral and was interviewed before Oct 2022. There were 3 interview rounds.

Round 1 - Resume Shortlist 
Pro Tip by AmbitionBox:
Keep your resume crisp and to the point. A recruiter looks at your resume for an average of 6 seconds, make sure to leave the best impression.
View all Resume tips
Round 2 - Group Discussion 

How to collect money from Debt customer

Round 3 - One-on-one 

(1 Question)

  • Q1. Why we should hire you

Interview Preparation Tips

Interview preparation tips for other job seekers - NA

MIS Executive Interview Questions Asked at Other Companies

Q1. HOW TO CREATING PIVOT TABLE IN EXCEL. HOW MANY PIVOT TABLES YOU W ... read more
Q2. Excel function explain Pivot table. Vlookup.hole look-up.xlook-up ... read more
asked in HCLTech
Q3. What is the advantages of Data validation and why we use it?
Q4. WHAT YOU KNOW ABOUT ADVANCED EXCEL .AND EXPLAIN ABOUT THE CONDITI ... read more
Q5. Which formula do you know in excel Get this value usinhlg vlookup ... read more

Interview questions from similar companies

I applied via Other and was interviewed before Feb 2020. There were 3 interview rounds.

Interview Questionnaire 

4 Questions

  • Q1. Do you have good knowledge of MS OFFICE specially MS EXCEL?
  • Q2. Have you ever worked on MIS profile?
  • Q3. Tell us something about yourself and banking industry?
  • Q4. Typee in 5 minutes the entire's day schedule of yours ??

Interview Preparation Tips

Interview preparation tips for other job seekers - Be confident and presentable always.
Interview experience
5
Excellent
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Selected Selected

I applied via Referral and was interviewed in Nov 2023. There was 1 interview round.

Round 1 - Aptitude Test 

Excel Text, and work experience

Interview experience
3
Average
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
No response

I applied via Walk-in and was interviewed in Apr 2024. There was 1 interview round.

Round 1 - Assignment 

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

Topics to prepare for Mahindra Finance MIS Executive interview:
  • Advanced Excel
Interview preparation tips for other job seekers - Normal about yourself, salary expectation there budget is around 3 lacs as per my assumption. mon to fri day shifts and need to extend the shift as well.
Round 1 - Resume Shortlist 
Pro Tip by AmbitionBox:
Keep your resume crisp and to the point. A recruiter looks at your resume for an average of 6 seconds, make sure to leave the best impression.
View all Resume tips
Round 2 - HR 

(3 Questions)

  • Q1. What are your salary expectations?
  • Q2. Tell me about yourself.
  • Q3. Your fev sport Which cricket player do you like What do you better batting or bowling Which position you like to bat in gully cricket What is you birth state Who is the cm of your native state Who is forme...
Round 3 - Technical 

(1 Question)

  • Q1. Which formula do you know in excel Get this value usinhlg vlookup What is vlookup and its argument Use of concatenate formula Extract only day in date time formate
  • Ans. 

    VLOOKUP is a formula in Excel used to search for a value in a table and retrieve corresponding data from another column.

    • VLOOKUP is used to find an exact or approximate match in a table.

    • Its arguments include the lookup value, table range, column index, and match type.

    • Concatenate formula is used to combine text from multiple cells into one cell.

    • It is helpful for creating unique identifiers or joining data from different ...

  • Answered by AI

Interview Preparation Tips

Interview preparation tips for other job seekers - No advice, you have to prepare your best

Skills evaluated in this interview

Interview experience
4
Good
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Technical 

(2 Questions)

  • Q1. About Excel like VLOOKUP index match pivot table
  • Q2. Communication is not important you attitude is matter

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...

  • Answered by AI
  • 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...

  • Answered by AI
  • 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

  • Answered by AI
  • 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.

  • Answered by AI

Skills evaluated in this interview

Interview experience
5
Excellent
Difficulty level
Moderate
Process Duration
-
Result
-
Round 1 - Aptitude Test 

Essy writing english grammet

Round 2 - HR 

(2 Questions)

  • Q1. Self introduction
  • Q2. Basic questions about bank
Interview experience
5
Excellent
Difficulty level
Easy
Process Duration
Less than 2 weeks
Result
Selected Selected

I applied via Referral and was interviewed before Apr 2023. There was 1 interview round.

Round 1 - One-on-one 

(1 Question)

  • Q1. What are your previous work?
Contribute & help others!
anonymous
You can choose to be anonymous

Home Credit Finance Interview FAQs

How many rounds are there in Home Credit Finance MIS Executive interview?
Home Credit Finance interview process usually has 2 rounds. The most common rounds in the Home Credit Finance interview process are Group Discussion, Resume Shortlist and One-on-one Round.
How to prepare for Home Credit Finance MIS Executive interview?
Go through your CV in detail and study all the technologies mentioned in your CV. Prepare at least two technologies or languages in depth if you are appearing for a technical interview at Home Credit Finance. The most common topics and skills that interviewers at Home Credit Finance expect are Advanced Excel, Pivot Table and VLOOKUP.

Recently Viewed

PHOTOS

InsuranceDekho

3 office photos

LIST OF COMPANIES

Credit Bajaar

Overview

REVIEWS

Kalpataru Projects International

No Reviews

REVIEWS

Kalpataru Projects International

No Reviews

REVIEWS

Kalpataru Projects International

No Reviews

INTERVIEWS

Persistent Systems

No Interviews

SALARIES

Kalpataru Projects International

INTERVIEWS

HDB Financial Services

No Interviews

INTERVIEWS

HDB Financial Services

No Interviews

REVIEWS

Kalpataru Projects International

No Reviews

Tell us how to improve this page.

Home Credit Finance MIS Executive Interview Process

based on 2 interviews

Interview experience

4
  
Good
View more

Fast track your campus placements

View all
Home Credit Finance MIS Executive Salary
based on 12 salaries
₹2 L/yr - ₹3.6 L/yr
15% less than the average MIS Executive Salary in India
View more details

Home Credit Finance MIS Executive Reviews and Ratings

based on 4 reviews

3.1/5

Rating in categories

3.1

Skill development

4.0

Work-life balance

3.1

Salary

2.1

Job security

4.0

Company culture

2.1

Promotions

3.0

Work satisfaction

Explore 4 Reviews and Ratings
District Sales Manager
310 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Sales Executive
280 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Assistant Manager
272 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Operator
272 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Collections Executive
269 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Explore more salaries
Compare Home Credit Finance with

Bajaj Finance

4.0
Compare

HDFC Bank

3.9
Compare

ICICI Bank

4.0
Compare

Tata Capital

4.1
Compare
Did you find this page helpful?
Yes No
write
Share an Interview