Question 1

What is the purpose of an MIS?

Accepted Answer

The primary purpose of an MIS is to assist the management in making strategic, tactical and operational decisions.

Question 2

What are the different types of MIS?

Accepted Answer

The different types of MIS are: Databank Information System Predictive Information System Decision Information System Decision Information System

Question 3

What is the core principle of MIS?

Accepted Answer

he 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.

Question 4

What are the levels of information requirements in an MIS?

Accepted Answer

The levels of information requirements in an MIS are: Organisation level Application level Technical level Database level

Question 5

What are the levels of decision making in MIS?

Accepted Answer

The levels of decision making in MIS are: Strategic Technical

Question 6

What are the elements of decision making in MIS?

Accepted Answer

The elements of decision making in MIS are: Model Constraint Optimisation

Question 7

What is a Database Information System?

Accepted Answer

A Databank Information System is the framework for creating a database by classifying and storing data which will be potentially useful to the decision makers.

Question 8

What are the different approaches used in designing and MIS?

Accepted Answer

The different approaches used in designing an MIS are: Organisation-chart approach Integrate-later approach Data-collection approach Database approach Top-down approach

Question 9

How can you protect your worksheet from anyone editing the data?

Accepted Answer

There are two ways in order to prevent anyone from editing the data: 1. 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. 2. 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.

Question 10

How to create a drop-down list so that users cannot enter unwanted data?

Accepted Answer

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.

Question 11

Is it possible to make a pivot table using data from multiple sources?

Accepted Answer

Yes, it is possible to make a pivot table from multiple worksheets if it is located in the same workbook.

Question 12

How do you freeze rows and columns simultaneously?

Accepted Answer

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 pains).

Question 13

What is the constraint of a VLOOKUP function?

Accepted Answer

The one constraint with VLOOKUP is that the Lookup Value must be in the leftmost column of the Table Range.

Question 14

How many report formats are available in MS Excel?

Accepted Answer

There are three report formats in MS Excel u2013 compact, report and tabular.

Question 15

What logical condition will you use when there are two different criteria?

Accepted Answer

Use the AND logical condition when there are two different criteria.

Tag: Business Analytics

Top 40 MIS Executive Interview Questions & Answers

Frequently Asked Data Warehouse Interview Questions and Answers

How To Switch From Software Engineer To Business Analyst?

Tag: Business Analytics

Top 40 MIS Executive Interview Questions & Answers

Business Analytics – A Must Have Skill in a World Drowning in Data

Frequently Asked Data Warehouse Interview Questions and Answers

How To Switch From Software Engineer To Business Analyst?