Vlookup, pivot tables and few functions.
Mis Intern Interview Questions
648 mis intern interview questions shared by candidates
An excel workbook was given which had raw data in 2 different sheets and one reference workbook was given which had all the summary of the data in sheet1. Based on reference sheet, try to duplicate and summarize the raw data. Also raw data workbook will be in 2 separate sheets so you will have to prepare the data in a single sheet by merging those 2 raw sheets. Merging can be done manually or by power query. Things to be prepared - Pivot Table, YOY Growth in percentage, Power Query to merge sheets
introduce yourself
They Asked me about current job and VBA related questions.
how to calculate Attrition how to calculate shrinkage how to aaply vlookup how to apply Hlookup in what scenario countif sumif if will be used what is Data validation ho to apply macros
He asked many out of region question that is not necessary for a MIS executive at all.
About My Experience, Current Job role details & Technical Part.
Do you think that you can able to manage the Entire Zone.
In the Excel Test, the questions will be very easy. In managerial round they will ask you to explain all the formulae you have used in the Excel Test. All the formula have to be dynamic.
Technical interview : mainly revolved around MS excel questions. had almost 3 question.
Viewing 391 - 400 interview questions