MIS Specialist

filter-iconFilter interviews by

MIS Specialist Interview Questions and Answers

Updated 24 Jun 2024

Q1. What is index+match

Ans.

Index+match is a combination of Excel functions used to lookup a value in a table based on row and column criteria.

  • Index function returns the value of a cell in a table based on the row and column number provided

  • Match function returns the position of a value in a range

  • Index+match is commonly used instead of Vlookup for more flexibility and accuracy

  • Example: =INDEX(A1:D10, MATCH(123, B1:B10, 0), 3) will return the value in the 3rd column of the row where 123 is found in column ...read more

Q2. What is vlookup

Ans.

VLOOKUP is a function in Excel used to search for a value in a table and return a corresponding value from another column.

  • 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 value in cell A2 in the range B2:D10 and retur...read more

MIS Specialist Jobs

MIS Specialist 3-7 years
Livpure
4.0
Gurgaon / Gurugram
MIS Specialist 3-5 years
Vserve Digital Solutions
4.1
₹ 2 L/yr - ₹ 3 L/yr
Gurgaon / Gurugram
Finance and MIS Specialist 4-6 years
bluestar limited
4.1
Mumbai
Are these interview questions helpful?
Interview Tips & Stories
Ace your next interview with expert advice and inspiring stories

Interview experiences of popular companies

3.1
 • 466 Interviews
3.9
 • 241 Interviews
3.7
 • 48 Interviews
3.8
 • 11 Interviews
View all

Calculate your in-hand salary

Confused about how your in-hand salary is calculated? Enter your annual salary (CTC) and get your in-hand salary

Recently Viewed
COMPANY BENEFITS
ACKO
No Benefits
SALARIES
ACKO
No Salaries
JOBS
ACKO
No Jobs
INTERVIEWS
MITA
No Interviews
REVIEWS
ACKO
No Reviews
LIST OF COMPANIES
ACKO
Overview
INTERVIEWS
WovVTech
No Interviews
INTERVIEWS
Affinity
No Interviews
INTERVIEWS
InFynd
No Interviews
PHOTOS
ACKO
No Photos
MIS Specialist Interview Questions
Share an Interview
Stay ahead in your career. Get AmbitionBox app
qr-code
Helping over 1 Crore job seekers every month in choosing their right fit company
65 L+

Reviews

4 L+

Interviews

4 Cr+

Salaries

1 Cr+

Users/Month

Contribute to help millions

Made with ❤️ in India. Trademarks belong to their respective owners. All rights reserved © 2024 Info Edge (India) Ltd.

Follow us
  • Youtube
  • Instagram
  • LinkedIn
  • Facebook
  • Twitter