ICICI Bank Manager - MIS Interview Questions and Answers

Essy writing english grammet

Q1. Self introduction
Add your answer
Q2. Basic questions about bank
Add your answer

Q1. Do you know Excel
Add your answer
Q2. V lookup aata h
Add your answer
Q3. H lookup aata h
Add your answer
Q4. Pivot table aata h
Add your answer
Q5. Sare formulas yaad h
Add your answer

Q1. Tell me about your self
Ans. 
I am a highly motivated MIS Executive and Analyst with experience in data analysis and system management.
• I have a strong background in data analysis and management

• I am proficient in various programming languages and software applications

• I have experience in system management and troubleshooting

• I am a quick learner and can adapt to new technologies and processes easily
Answered by AI
Add your answer
Q2. Knowledge regarding banking, transaction, account escrow ??
Add your answer
Q3. Excel - related data preparation for making pivot table and dashboard formation
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. Introduce yourself
Add your answer
Q2. What is your weakness
Add your answer
Q3. What is ur goal
Ans. 
My goal is to continuously improve my skills and knowledge in the field of MIS and contribute to the success of the organization.
• To stay updated with the latest technologies and trends in MIS

• To enhance my problem-solving and analytical skills

• To work collaboratively with the team and share my knowledge and expertise

• To achieve the goals and objectives of the organization through effective MIS management

• To continuously le
Answered by AI
Add your answer

Q1. About Death claim process and cross questioning
Add your answer
Q2. About traditional and guaranteed plan
Add your answer

Q1. Golden rule of marketing
Ans. 
The golden rule of marketing is to understand and meet the needs of the customer.
• Customer is the king

• Identify customer needs and preferences

• Create products/services that fulfill those needs

• Communicate effectively with customers

• Build long-term relationships with customers

• Examples: Apple's customer-centric approach, Amazon's personalized recommendations
Answered by AI
Add your answer
Q2. Tell 4 p of marketing
Ans. 
4 P's of marketing are Product, Price, Place, and Promotion.
• Product: refers to the goods or services offered by a company

• Price: refers to the amount customers pay for the product

• Place: refers to the location where the product is sold or distributed

• Promotion: refers to the marketing activities used to promote the product
Answered by AI
View 1 more answer

Questions were came from 10th standard basis, in aptitude test the all questions were came from all subjects for test

Q1. Share details of your previous job.
Add your answer
Q2. What are your strengths and weaknesses?
Add your answer
Q3. What are your salary expectations?
Add your answer
Q4. Tell me about yourself.
Add your answer
Q5. Hr didn't ask any other questions.
Add your answer

Q1. Asked excel formula which is used to make MIS.
Add your answer