Senior MIS Analyst

filter-iconFilter interviews by

Senior MIS Analyst Interview Questions and Answers

Updated 29 May 2021

Popular Companies

Q1. how can you protect your sheet from anyone editing the data

Ans.

Protect sheet from editing by setting password and restricting access.

  • Set a password to protect the sheet

  • Restrict access to the sheet by only allowing authorized users to edit

  • Use Excel's Protect Sheet feature to prevent editing

  • Use VBA code to protect the sheet and prevent unauthorized access

Q2. how many report formats are available in MS Excel

Ans.

There are several report formats available in MS Excel.

  • Excel offers various report formats such as tables, charts, pivot tables, and pivot charts.

  • Tables are used to organize data in rows and columns.

  • Charts are used to visually represent data in different formats such as bar, line, and pie charts.

  • Pivot tables are used to summarize and analyze large amounts of data.

  • Pivot charts are used to visually represent data from pivot tables.

  • Excel also offers other report formats such as ...read more

Q3. what is the constraint of a VLOOKUP function

Ans.

The constraint of a VLOOKUP function is that it can only look up values in the leftmost column of a table.

  • VLOOKUP can only search for values in the first column of a table

  • The lookup value must be in the leftmost column of the table

  • If you need to search for values in other columns, you need to use INDEX/MATCH instead

Q4. how do prepare an MIS report in excel

Ans.

To prepare an MIS report in Excel, follow these steps:

  • Identify the data to be included in the report

  • Organize the data in a structured format

  • Use Excel functions and formulas to calculate metrics

  • Create charts and graphs to visualize the data

  • Format the report for readability and clarity

  • Include a summary or conclusion section

  • Save the report and share with relevant stakeholders

Are these interview questions helpful?

Q5. How many numbers you will give yourself on excel

Ans.

I would give myself a 9 out of 10 for Excel proficiency.

  • I am highly skilled in Excel and can perform complex tasks efficiently.

  • I have experience in creating pivot tables, charts, and graphs.

  • I am proficient in using Excel functions such as VLOOKUP, SUMIF, and COUNTIF.

  • I am familiar with macros and VBA programming in Excel.

  • I am constantly learning and improving my Excel skills.

Q6. what is MIS, what is purpose of an MIS

Ans.

MIS stands for Management Information System. It is a computer-based system that provides information to support decision-making.

  • MIS collects, processes, and stores data from various sources.

  • It generates reports and provides analysis to support decision-making.

  • MIS helps in planning, controlling, and organizing business operations.

  • Examples of MIS include ERP systems, CRM systems, and financial management systems.

Share interview questions and help millions of jobseekers 🌟

man-with-laptop

Q7. what are the different type of MIS

Ans.

MIS stands for Management Information System. There are mainly four types of MIS: Strategic, Tactical, Operational, and Decision Support System.

  • Strategic MIS: Helps in long-term planning and decision-making.

  • Tactical MIS: Helps in short-term planning and decision-making.

  • Operational MIS: Helps in day-to-day operations and monitoring.

  • Decision Support System: Helps in complex decision-making by providing analytical tools and models.

  • Examples: ERP, CRM, SCM, Business Intelligence, ...read more

Senior MIS Analyst Jobs

Senior MIS Analyst 5-7 years
24-7 Intouch
2.9
Hyderabad / Secunderabad
Senior Mis Analyst 5-10 years
Atech Solutions
3.7
₹ 3 L/yr - ₹ 5 L/yr
New Delhi
Interview Tips & Stories
Ace your next interview with expert advice and inspiring stories

Interview experiences of popular companies

3.9
 • 1.8k Interviews
3.9
 • 1.5k Interviews
3.7
 • 795 Interviews
3.8
 • 176 Interviews
3.6
 • 106 Interviews
4.0
 • 48 Interviews
3.7
 • 28 Interviews
4.2
 • 19 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
LIST OF COMPANIES
S2 Technology & Consulting
Overview
SALARIES
S2 Technology & Consulting
No Salaries
SALARIES
MRF Tyres
REVIEWS
S2 Technology & Consulting
No Reviews
INTERVIEWS
Ingenico Group
No Interviews
INTERVIEWS
Fidel Softech
No Interviews
SALARIES
Kyb Motorcycle Suspension
No Salaries
LIST OF COMPANIES
Kyb Motorcycle Suspension
Overview
COMPANY BENEFITS
Kyb Motorcycle Suspension
No Benefits
REVIEWS
MRF Tyres
No Reviews
Senior MIS Analyst 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