Reliance General Insurance Manager - MIS Interview Questions and Answers

Q1. Vlookup, index match, pivot table
Add your answer
Q2. Special pest, unique data, countif
Add your answer

Q1. Excell related questions
Add your answer
Q2. Vlookup pivot table conditional formatting
Add your answer
Q3. Only excell related
Add your answer

Q1. What is pivot table
Ans. 
A pivot table is a data processing tool used to summarize, analyze, explore, and present large amounts of data in a spreadsheet format.
• Pivot tables allow users to reorganize and summarize selected columns and rows of data to obtain desired insights.

• Users can easily group, sort, filter, and calculate data within a pivot table.

• Pivot tables are commonly used in Excel and other spreadsheet software for data analysis and re...read more
Answered by AI
Add your answer
Q2. What is primary key
Ans. 
Primary key is a unique identifier for each record in a database table.
• Primary key ensures each record in a table is unique

• It can be a single column or a combination of columns

• Primary key values cannot be null

• Example: In a table of students, student ID can be a primary key
Answered by AI
Add your answer

Q1. Why you want to join our company
Ans. 
I am impressed by your company's innovative approach and strong reputation in the industry.
• Your company's commitment to cutting-edge technology

• Strong reputation for quality and customer satisfaction

• Opportunities for growth and advancement within the company
Answered by AI
Add your answer

Q1. What is your current role and what are your achievements
Add your answer
Q2. What are challenges you faced in your current organisation
Add your answer

Q1. Create pivot table base on givn table
Ans. 
To create a pivot table, select the data range and go to Insert tab > PivotTable.
• Select the data range

• Go to Insert tab > PivotTable

• Choose the location for the pivot table

• Drag and drop the fields into the Rows, Columns, and Values areas

• Apply filters and formatting as needed
Answered by AI
Add your answer
Q2. Consolidate data as per the requirement
Add your answer
Q3. Function in excel like vlook up, left, substitue,countif,
Add your answer
Q4. Simple Reasoning questions
Add your answer

Q1. About current job working
Add your answer
Q2. Why u are leaving current job
Ans. 
Seeking new challenges and growth opportunities.
• Looking for a more challenging role

• Seeking career advancement

• Want to broaden my skillset

• Current job lacks growth opportunities

• Company restructuring or downsizing

• Relocation or commute issues
Answered by AI
Add your answer
Q3. Some advance excel Fun and macro and VBA basic
Add your answer

Advance excel test like sumif countif vlookup pivote

Q1. About current company profile and previous company profile
Add your answer
Q2. About yourself and current and previous company background
Add your answer