HDFC Bank MIS Coordinator Interview Questions and Answers

Q1. Vlookup question on data
Add your answer
Q2. Pivot table and dashboard preparation
Add your answer

Q1. Do you know vlookup?
Ans. 
Yes, vlookup is a function in Excel used to search for a value in a table and return a corresponding value.
• Vlookup stands for 'vertical lookup'

• It is commonly used in Excel to search for a value in the leftmost column of a table and return a value in the same row from a specified column

• Syntax: =VLOOKUP(lookup_value, table_array, col_index_num, [range_lookup])

• Example: =VLOOKUP(A2, B2:D10, 3, FALSE) - searches for the val...read more
Answered by AI
Add your answer
Q2. Do you know pivot table
Ans. 
Yes, pivot tables are used in Excel to summarize and analyze data.
• Pivot tables are used to summarize large amounts of data in Excel.

• They allow users to reorganize and summarize selected columns and rows of data.

• Users can easily create different views of the data by dragging and dropping fields.

• Pivot tables can also perform calculations and display results in a clear and organized manner.

• For example, you can use a pivot...read more
Answered by AI
Add your answer

Q1. Kiosk banking all of this
Add your answer
Q2. Acc opening in bank
Ans. 
The question is about opening an account in a bank.
• Discuss the process of opening an account in a bank

• Explain the required documents and identification

• Mention any specific account types or features

• Highlight any promotional offers or benefits
Answered by AI
Add your answer
Q3. Money transfer by kiosk
Add your answer

Job family and exprince

Self introduction ;::&&$$'''':::;

Q1. Excel test for example v lookup h lookup etc.
Add your answer

Q1. Salry discussion time related
Add your answer

Q1. Prioves work experience they are asking
Add your answer
Q2. Work related questions asking
Add your answer
Q3. And package details asking
Add your answer

Q1. Tell me about yourself?
Ans. 
I am an experienced MIS Executive with a strong background in managing information systems and providing data-driven insights.
• Experienced MIS Executive

• Skilled in managing information systems

• Expertise in providing data-driven insights

• Proficient in data analysis and reporting

• Strong problem-solving and communication skills
Answered by AI
Add your answer
Q2. Where did you hear about this Company?
Ans. 
I heard about this company through a job posting on a popular job search website.
• Job posting on a popular job search website

• Referral from a friend or colleague

• Social media advertisement

• Company's official website
Answered by AI
Add your answer
Q3. What's your qualification?
Ans. 
I have a Bachelor's degree in Management Information Systems (MIS) and relevant work experience.
• Bachelor's degree in MIS

• Relevant work experience

• Proficient in database management

• Strong analytical and problem-solving skills
Answered by AI
Add your answer
Q4. What's Your work experience?
Ans. 
I have 5 years of work experience in the field of MIS, with a focus on data analysis and reporting.
• Worked as an MIS Executive at XYZ Company for 3 years

• Responsible for managing and analyzing large datasets

• Created and maintained reports using Excel and SQL

• Developed automated dashboards for real-time data monitoring

• Collaborated with cross-functional teams to identify and address data-related issues
Answered by AI
Add your answer