MIS Executive

Skills Required:

❖ Hire a MIS Executive who is good with Advance Excel.

❖ Thorough Knowledge of Excel or Google Sheets

❖ Should know Pivot Tables

❖ A background in Mathematics will help

Experience: 3-5 years Working Experience as mis

1. Explain the difference between VLOOKUP and INDEX(MATCH)
2. .v look and index matching - whats the difference
3. do u know array formulaes
4. do you stay updated with new Google Sheets features and formulas
5. how you would use COUNTIF to identify duplicates in a column
6. How would you create a dynamic dropdown list that updates automatically when source data changes
7. an employee says currently “This formula isn't working” - walk me through your troubleshooting approach.
8. a company maintains 5 different Excel files for inventory across departments. How would you consolidate this into a single Google Sheets system
9. knowledge of Google Apps Script (even basic)
10.