HDFC Bank MIS Coordinator Interview Questions and Answers for Experienced

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 MIS excel in brief. What would you know about MIS Excel
Add your answer

Q1. Communication skill, previous job details
Add your answer