Are you looking for the most-frequently asked MIS Executive interview questions? This article has a detailed list of some of the most popular MIS interview questions and answers asked in any top company’s MIS executive interview round. These questions will help you to prepare for the interview so that you show your extreme MIS skills during the interview round as it covers a variety of questions as per the skills required to become an MIS Executive.
What is MIS?
An MIS (Management Information System) is a system that is used to collect, process, store, and disseminate data or information to support the management. An MIS Executive is a professional who is responsible for maintaining the existing MIS of an organization. With experience and skills, you can further your career path to becoming a Data Analyst, Business Analyst, or Research Analyst.
The most important skills that are associated with an MIS Executive are MS Excel, SQL, and VBA. The interview questions here will cover these skills. Some of the top MIS Executive Interview Questions & Answers are:
General MIS Executive Interview Questions
Q1. What is the purpose of an MIS?
Ans. The primary purpose of an MIS is to assist the management in making strategic, tactical, and operational decisions. It offers up-to-date information on the company’s assets and helps various departments like – Marketing, finance, R&D, manufacturing, etc. From storing data to making it accessible, MIS is a crucial aspect of every business today. Other primary objectives are:
- Data storage
- Data retrieval
- Data propagation
- Graphical report making
Explore courses related to MIS:
|Popular Business Analytics Courses||Top Business Data Mining Courses|
|Popular Database Courses||Top Business Tools Courses|
Q2. What are the different types of MIS?
Ans. The different types of MIS are:
- Databank Information System – This form of information system helps in observing, classifying, and storing data items which helps the decision-maker in taking data-driving decisions.
- Predictive Information System – This form of information system is used to draw presumptions and predictions that are relevant to decision making.
- Decision Support System – DSS is used to gather, analyze, and synthesize data for producing comprehensive information reports.
Q3. What is the core principle of MIS?
Ans. The core principle of MIS is to facilitate decision making by supplying up-to-date and accurate information to people who need it on time in a usable form. Apart from this MIS also helps in:
- Offering the right facts
- Supporting pre-defined internal control
- Dealing with operating procedures
- Preparing for company audit
- Creating desired reports
Q4. What are the levels of information requirements in an MIS?
Ans. The levels of information requirements in an MIS are:
- Organization level
- Technical level
- Database level
Q5. What are the levels of decision making in MIS?
Ans. Most managers use information systems to improve their decision-making capabilities. MIS helps the different levels of managers in taking different levels of decisions (whether decisions for an individual or on behalf of a group). Having a dependable MIS system helps the following levels of decision making:
- Senior management
- Strategic level management
- Technical experts
- Middle management and project teams
- Operations management
- Individual employees
Q6. What are the elements of decision making in MIS?
Ans. This is a follow-up MIS interview question to measure your technical expertise in the field. The elements of decision making in MIS are:
Q7. What are the advantages of MIS in a business?
Ans. In business, MIS offers the following types of advantages:
- Single database access to all stakeholders
- Saves time of managers from operational work which can be utilized in other productive tasks
- Enhance the power of data and helps in decision making
- Ensures a high degree of accuracy
- Reduces the paperwork
- Helps in making easy to digest reports
- States the current financial position of the company to business leaders
- Offers competitive advantage
Do support the answer to this MIS interview question with examples.
Q8. What are the different approaches used in designing an MIS?
Ans. The different approaches used in designing an MIS are:
- Organisation-chart approach
- Integrate-later approach
- Data-collection approach
- Database approach
- Top-down approach
Q9. What strategies do you follow to successfully apply management information systems to a business?
Ans. Before applying a fully-functional MIS, an MIS executive should keep the following tips in mind:
- Understand the primary need of having an MIS
- Outline the goals of a company before deciding on the type of MIS
- Reach out to multiple vendors and decide the best one based on their offerings, cost, benefits, updates, training support, technical support, etc.
- Train the existing employees to successfully run and track large size data
MS Excel Questions for an MIS Executive Interview Questions Round
Q10. How can you protect your worksheet from anyone editing the data?
Ans. There are two ways in order to prevent anyone from editing the data:
- You can password protect the worksheet so that only those who have the password can open the sheet. To do this go to Menu bar >Review > Protect Sheet > Password.
- Lock the range. First, select the range that you want to lock, then right-click anywhere. Then go to the ‘Format Cells’ option from the drop-down menu and go to ‘Protection’ tab. There tick the ‘Locked’ option if it isn’t ticked, then press OK.
Also Read>> How To Become a Business Analyst?
Q11. How to create a drop-down list so that users cannot enter unwanted data?
Ans. We can create a drop-down list to limit data entry using ‘Data Validation’. First of all, create a list that you want to use as a drop-down list. Then go to Menu bar>Data>Data Validation. From the drop-down click ‘data validation’ and in settings select Allow: list. A source area will appear. Clicking on the source area, select the list of data you created at first and press OK.
Q12. Is it possible to make a pivot table using data from multiple sources?
Ans. Yes, it is possible to make a pivot table from multiple worksheets if it is located in the same workbook.
Q13. How do you freeze rows and columns simultaneously?
Ans. Click the cell from where you want to freeze the required columns and rows. Then go to Menu bar > View > Freeze panes > the first option (‘Freeze panes’).
Q14. What is the constraint of a VLOOKUP function?
Ans. The one constraint with VLOOKUP is that the Lookup Value must be in the leftmost column of the Table Range.
Also Read>> 10 Formulas to utilize MS-Excel at its best!
Q15. How many report formats are available in MS Excel?
Ans. There are three report formats in MS Excel – compact, report, and tabular.
Q16. What logical condition will you use when there are two different criteria?
Ans. Use the ‘AND” logical condition when there are two different criteria.
Q17. How do you prepare an MIS report in Excel?
Ans. Follow the below steps:
- Collect raw data from a different department
- Combine data in excel
- Link your data to your MIS template by using formulas like Vlookup, Hlookup, Sumifs, Sumif, INDEX & MATCH, Charts, etc. based on the needs
- Check for any #N/A, any #values, etc.
Also Read>> 7 Excel Tricks to get work done faster!
Q18. What do you know about VLOOKUP?
Ans. VLOOKUP is an Excel function that is used to lookup and retrieves data from a specific column in an excel table. VLOOKUP supports approximate and exact matching. In VLookup, the “V” stands for “vertical”. Also, the lookup values must appear in the first column of the table, with lookup columns to the right.
Purpose: Lookup a value in a table by matching on the first column
Return Value: Matched value from a table
Syntax: =VLOOKUP (lookup_value, table_array, col_index, [range_lookup])
Q19. What is the Logical Function?
Ans. There are 4 logical functions – AND, OR, XOR, and NOT. A Logical function helps in:
- Checking if a condition is true or false
- Combine two or more conditions together
Q20. How to format an open MIS Report (.csv to .xlsx)Excel?
Ans. An MIS executive must follow the below steps using MIS Report Format Add-in:
- Open the MIS Report file (.csv) in Excel (2016)
- Select the ISO-NE MIS Viewer tab in Microsoft Excel
- Select Format Report
This will format the MIS report and will leave the original MIS Report unaffected.
Q21. Explain 2 advanced Pivot Table techniques on Excel.
Ans. Slicer is a helpful tool in linking multiple pivot tables. You can even mention that it will help in filtering data for all the pivot tables. It saves plenty of time.
Another good time-saving technique is to create a calculated field. This is how it can be set up:
- Visit ‘Pivot Table Analyse’
- Select ‘Fields, Items and Sets
- Click on the ‘Calculated Field’ option
- Enter the name of the new calculated field
Suggested Reading – What is Business Analytics?
Q22. What is a condition and why does it matter?
Ans. In Excel, a condition determines the expression of the values stating either it is true or false. The expression could be a function that determines if the value entered in a cell is of numeric or text data type, if a value is greater than, equal to or less than a specified value, etc.
- =IF(logical_test, [value_if_true], [value_if_false])
- =OR(logical1, [logical2], …)
Also Read>> Why a course in Excel is worth it!!
VBA Questions Asked During MIS Executive Interview Round
Q23. What is the difference between DIM and SET?
Ans. DIM declares the variable. E.g. Dim r As Range. On the other hand, SET sets the variable to an object reference. E.g. Set r = Range(“A1”).
Q24. Write a VBA program to copy data from a worksheet to another?
Ans. Sub CopyData()
Dim lastrow, lastcol as Integer
lastrow = Worksheets(“name_of_the_worksheet”).rows.usedrange.count
lastcol = Worksheets(“name_of_the_worksheet”).columns.usedrange.count
Worksheets(“name_of_the_worksheet”).Range(lastrow, lastcol).Copy Worksheets(“name_of_the_worksheet_to_be_copied”).Range(“cell_name_where_you_want_to_copy”)
Also Read>>Why Managers Should Learn Programming
Q25. What is Option Explicit and Option Base?
Ans. Option Explicit makes the declaration of the variables mandatory. Option Base is used at the module level to declare the default lower bound for array subscripts.
Q26. What is the difference between ActiveWorkbook and ThisWorkbook?
Ans. ActiveWorkbook is the workbook that is open and active while the VBA code is running while ThisWorkbook refers to the workbook where the code is present.
Q27. How can you stop VBA script when it goes into the infinite loop?
Ans. Ctrl + Pause/Break is used to stop VBscript if it goes into an infinite loop.
Q28. How can you pass arguments to VBA functions?
Ans. If the arguments are approved to VBA function, the following two ways will help in passing the arguments to VBA functions:
- ByRef – The called procedure may change the value of the argument passed
- ByVal – The called procedure does not want to change the value of the argument passed
Q29. Which are some of the different types of error handling techniques?
Ans. The following are three different types of error handling techniques:
- On Error Goto 0
- On Error Goto Err_Lbl
- On Error Resume Next
Also Explore- Big Data Analytics Online Courses & Certifications
Q30. Give the shortcuts for following Excel VBA:
Ans. This is a common MIS interview question that aspiring MIS executives must know thouroughly.
|Open the VB Editor||Alt+F11|
|Step through each line of code||F8|
|open the Immediate Window||Ctrl+G|
|Delete a Line of Code||Ctrl+Y|
|Check parameters in a property, method, or function||Ctrl+i|
|Step out of code||Ctrl+Shift+F8|
|Resume execution though the error handler||Alt + F5|
|Show the call stack||Ctrl+L|
Q31. How do you count a string in excel?
Ans. By using Count A we can count a string in excel.
Q32. Highlight the main differences among VB6, VBA, VBScript and VB.Net.
Ans. VBA stands for Visual Basic for Applications. It is a Macro language across all Microsoft Office tools.
VB6 is a Windows Application Development Programming Language. Developed by Microsoft, it stands for Visual Basic.
VB.NET is one of the .NET programming languages of Microsoft.
Q33. Name some of the categories of two data types?
Ans. Numeric data and non-numeric data are the two categories of data types.
|Numeric Data type||Non-numeric Data type|
|Byte||String (Fixed length)|
|Integer||String (Variable length)|
Q34. Can you elaborate on ADO, ODBC and OLEDB?
Ans. ADO is short for ActiveX Data Objects. It helps in manipulating the database structure.
ODBC stands for Open Database Connectivity. This technology is responsible for connecting a database client application to an external database.
OLEDDB stands for Object Linking and Embedding, Database. It allows accessing of data uniformly through several sources.
Q35. How do you pass arguments to VBA functions other than ByVal and ByRef?
Ans. There are a few ways to pass arguments:
- Optional arguments: The Optional keyword specifies arguments as Optional. An Optional argument should be declared as Variant data type. This enables the use of IsMissing function.
- Parameter Arrays: Other than the three fixed arguments mentioned above, one can also pass a number of random arguments. This is done by using the ParamArray keyword.
SQL Questions for MIS Executive Interview
Q36. What are the three main types of statements in SQL?
Ans. The three main types of statements in SQL are:
- Data Definition Language (DDL)
- Data Manipulation Language (DML)
- Data Control Language (DCL)
Also Explore – Top SQL Interview Questions and Answers
Q37. What is a Primary Key?
Ans. The Primary Key is a special type of Unique Key, which uniquely identifies each record in a database, and has a NOT NULL constraint.
Q38. How do you combine records from different tables based on related columns?
Ans. We can combine records from different tables based on related columns using a JOIN statement.
Q39. What are the different types of JOINs?
Ans. There are four types of JOINs:
- Inner – returns records that have matching values in both tables.
- Right – returns matching records from the left table and all records from the right table.
- Left – returns matching records from the right table and all records from the left.
- Full – return all records when there is a match in either of two tables.
Q40. How do ensure that your subquery is working fine?
Ans. Run the subquery independently to see if it gives the desired result. If it is running properly then, you should have no problem.
Q41. What do mean by XML Datatype?
Ans. XML datatype helps in storing XML documents in the SQL Server database.
Q42. Which command will you use to recompile the stored procedure at run time?
Ans. To recompile the stored procedure at run time, we use the RECOMPILE command.
Also Explore – Database and SQL Online Courses & Certifications
Q43. What is @@SPID in SQL?
Ans. @@SPID returns the session ID of the current user process.
SELECT @@SPID AS ‘ID’, SYSTEM_USER AS ‘Login Name’, USER AS ‘User Name’;
ID Login Name User Name
—— —————————— ——————————
11 ABC\xyz who
Q44. What is @@Version?
Ans. The @@VERSION results are presented as one nvarchar string. The SERVERPROPERTY (Transact-SQL) function helps in retrieving the individual property values.
SELECT @@VERSION AS ‘SQL Server Version’;
SELECT @@VERSION AS ‘SQL Server PDW Version’;
Q45. What are the Triggers?
Ans. In SQL, Triggers means a special type of pre-stored procedure that runs automatically as soon as an event occurs in the database server. There are four types of triggers in SQL:
- Instead of
The above questions should help you in getting started with your preparation for an MIS Interview. If you are looking to improve your skills, you can go for a professional certification course in MS Excel, SQL, or VBA. Naukri Learning offers a variety of courses that will help you to improve your skills, boost your career prospects, and earn a higher salary.
Q46. What should you do when a data disk gets overloaded?
Ans. To resolve this issue, one has to follow four different steps
- Assess: There are several reasons why it can occur. You can mention that it is first important to identify whether the problem is caused by CPU usage, exceeding network capacity, less memory and increased data cache. For these, running the ‘top’ program is essential.
- Stabilise: It is also essential to stabilise the server by managing rate-limiting, applying concepts such as graceful degradation.
- Improve: Setting up a CDN (content delivery network) and optimising it helps.
- Monitor: The use of server monitoring tools will further help in detecting future issues.
Q47. What is your understanding of DBMS?
Ans. It stands for Database Management System. This software stores, retrieves, manipulates and/or deletes users’ data. There are two types of DBMS:
- Relational Database Management System is where data is stored in a table and then used in relation to differently stored datasets. MySQL is one example.
- Non-relational Database Management System is used for storing only that type of data that can be altered on a frequent basis. Some common examples of it include MongoDB, Cassandra, etc.
Q48. Briefly explain the 3 types of index in SQL.
Ans. Unique Index is one that does not allow the data field to have duplicate values.
Clustered Index is responsible for reordering the physical order of the data table.
Non-clustered Index is responsible for maintaining a logical order of data and does not change the physical order.
Q49. What do you understand by ACID property in a database?
Ans. ACID is short for Atomicity, Consistency, Isolation, Durability. These four pillars ensure the efficiency of data transactions in a database and are essential for MIS executives to follow.
Atomicity means that if one part of the transaction is faulty, the entire transaction will fail. Consistency, on the other hand, entails that all data should meet the common rules of validity. Concurrency control is done through Isolation, while Durability ensures that no error can come in between transactions.
If you have recently completed a professional course/certification, click here to submit a review and get FREE certification highlighter worth Rs. 500.