vlookup,hlooup,and other formullas
Analyste Mis Interview Questions
708 analyste mis interview questions shared by candidates
quelle contrat pour être embaucher?
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
Availability for job at any point of time is expected and appreciated.
SQL - Given Case scenario - Solve SQL Query based on provided input.
Vlookup, pivot tables and few functions.
They Asked me about current job and VBA related questions.
introduce yourself
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.
Viewing 421 - 430 interview questions