200+ MIS Executive Interview Questions and Answers

To create a pivot table in Excel, go to the 'Insert' tab, click on 'PivotTable', select the data range, choose the location, and set the fields.

• Go to the 'Insert' tab in Excel

• Click on 'PivotTable'

• Select the data range you want to use for the pivot table

• Choose the location where you want the pivot table to be placed

• Set the fields for the pivot table by dragging and dropping them into the 'Rows', 'Columns', and 'Values' areas

• Apply any necessary filters or formatting to the pivo...read more

Excel functions including Pivot table, Vlookup, Xlookup, Duplicate remove, ERP, and SAP.

• Pivot table: summarizes and analyzes data in a table

• Vlookup: searches for a value in a table and returns a corresponding value

• Xlookup: a newer version of Vlookup with added features

• Duplicate remove: removes duplicate values from a table

• ERP: Enterprise Resource Planning software used for managing business processes

• SAP: Systems, Applications, and Products in Data Processing software used for...read more

Data validation ensures accuracy and completeness of data. It helps in preventing errors and improving data quality.

• Data validation ensures that the data entered is accurate and complete.

• It helps in preventing errors and improving data quality.

• It ensures that the data is consistent and conforms to predefined standards.

• It helps in identifying and correcting errors before they cause problems.

• Examples of data validation include checking for valid email addresses, phone numbers, ...read more

Conditional formatting in Advanced Excel allows users to apply formatting based on specified conditions.

• Conditional formatting is a feature in Excel that allows users to format cells based on certain conditions.

• It helps in highlighting data that meets specific criteria or rules.

• Users can choose from various formatting options like font color, cell color, data bars, icon sets, etc.

• Conditions can be based on values, formulas, or rules defined by the user.

• For example, you can us...read more

There are multiple types of data extraction methods and various ways to export the data.

• Types of data extraction methods include web scraping, database querying, API integration, and ETL processes.

• Data can be exported in various formats such as CSV, Excel, JSON, XML, or directly into databases.

• Exporting data can be done through software tools, programming languages, or using built-in export functionalities of applications.

• Examples of data extraction tools include Selenium for...read more

To find the number of repetitions of a particular text by formula.

• Use the COUNTIF function in Excel to count the number of times a specific text appears in a range of cells.

• Syntax: =COUNTIF(range, text)

• Example: =COUNTIF(A1:A10, "apple") will count the number of times the word "apple" appears in cells A1 to A10.

• Make sure to enclose the text in double quotes if it contains spaces or special characters.

To stop VBScript from an infinite loop, you can use the 'Ctrl + Break' keyboard shortcut or close the program through Task Manager.

• Use 'Ctrl + Break' keyboard shortcut to stop the script execution

• Close the program through Task Manager if 'Ctrl + Break' doesn't work

Religious beliefs should not be a factor in the selection process for a job.

• Religious beliefs should not impact one's qualifications or ability to perform a job.

• Employment decisions should be based on skills, experience, and qualifications.

• Discrimination based on religion is illegal and unethical.

• Focus on how my skills and experience make me a strong candidate for the position.

MATCH and INDEX are Excel functions used for different purposes.

• MATCH function is used to find the position of a value in a range or array.

• INDEX function is used to retrieve the value at a specific row and column intersection in a range or array.

• MATCH function returns the relative position of a value, while INDEX function returns the actual value.

• MATCH function can be used for approximate or exact matches, while INDEX function is used for exact matches only.

• MATCH function can...read more

To get raw data or work on your organization, you can utilize various methods such as accessing databases, using APIs, conducting surveys, or analyzing existing reports.

• Access databases to extract raw data

• Utilize APIs to retrieve data from external sources

• Conduct surveys to collect relevant information

• Analyze existing reports or documents within the organization

• Use data mining techniques to extract valuable insights

Logical function is a function that returns a value based on one or more input values.

• Logical functions are used in programming and mathematics to make decisions based on conditions.

• Examples include IF function in Excel, AND, OR, NOT functions in programming languages.

• They evaluate expressions and return true or false based on the conditions.

INDEX & MATCH in Excel are used together to lookup values in a table based on specific 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.

• Used together, INDEX & MATCH can perform advanced lookups that VLOOKUP or HLOOKUP cannot handle.

• INDEX & MATCH combination is more flexible and efficient for searching and retrieving data in Excel.

• Example: =INDEX(A1:A10, MATCH(B1...read more

VLOOKUP, HLOOKUP, SUMIFS, COUNTIFS, AVERAGEIFS, SUBTOTAL, IF, AND, OR, and Conditional Formatting are Excel functions used for data analysis and manipulation.

• VLOOKUP is used to search for a value in a table and return a corresponding value in the same row.

• HLOOKUP is similar to VLOOKUP, but searches for a value in a table and returns a corresponding value in the same column.

• SUMIFS is used to sum values in a range that meet multiple criteria.

• COUNTIFS is used to count the number...read more

To separate date and time, use a combination of string manipulation and date/time functions.

• Extract the date and time from the original string using string manipulation functions like substring or split.

• Convert the date and time strings into date/time objects using a date/time function like new Date() or moment().

• Format the date and time objects into the desired output format using a date/time function like toLocaleDateString() or toLocaleTimeString().

Excel and formulas are used for data analysis, calculations, and organizing information efficiently.

• Excel allows for easy data entry and manipulation.

• Formulas in Excel enable automated calculations and data analysis.

• Excel provides various functions and tools for data organization and visualization.

• Excel can handle large datasets and perform complex calculations.

• Formulas in Excel can be used for financial analysis, statistical analysis, and forecasting.

• Excel and formulas are w...read more

Yes, VLOOKUP is a formula used in Excel to search for a specific value in a column and return a corresponding value from another column.

• VLOOKUP stands for vertical lookup.

• It is commonly used to find data in large spreadsheets.

• The formula has four arguments: lookup value, table array, column index number, and range lookup.

• Example: =VLOOKUP(A2, B2:D10, 3, FALSE) will search for the value in cell A2 in the range B2:D10 and return the value from the third column.

• It is useful for ...read more

A pivot table is a data summarization tool used in spreadsheet programs to organize and analyze large amounts of data.

• Pivot tables allow users to quickly summarize and analyze data from different perspectives.

• They can be used to group and aggregate data based on different criteria.

• Pivot tables provide flexibility in rearranging and reorganizing data to gain insights.

• They help in identifying patterns, trends, and outliers in data.

• Pivot tables can be used to create reports and ...read more

Excel sheets can have up to 1,048,576 rows and 16,384 columns. The last column name in Excel is XFD. You can find data in a master table using filters or lookup functions.

• Excel sheets can have a maximum of 1,048,576 rows.

• Excel sheets can have a maximum of 16,384 columns.

• The last column name in Excel is XFD.

• To find data in a master table, you can use filters or lookup functions like VLOOKUP or INDEX-MATCH.

Yes, I can maintain a Chinese company's work policy by understanding and adhering to their cultural norms and regulations.

• I will familiarize myself with Chinese labor laws and regulations to ensure compliance.

• I will respect the hierarchical structure and communication style commonly found in Chinese companies.

• I will adapt to the work hours and holiday schedule followed by Chinese companies.

• I will prioritize building strong relationships with colleagues and superiors, as relat...read more

Optimizing business instances involves analyzing processes, identifying inefficiencies, and implementing solutions to improve performance.

• Identify key business processes that need optimization

• Analyze data to pinpoint inefficiencies and bottlenecks

• Implement automation or technology solutions to streamline operations

• Regularly monitor and evaluate performance to ensure continued optimization

A formula is a mathematical expression used to perform calculations, while a function is a predefined formula that performs a specific task.

• A formula is created by the user, while a function is built-in to the software.

• Formulas can be customized and modified, while functions have a fixed set of instructions.

• Formulas are typically used for calculations, while functions can perform various tasks like data manipulation, formatting, etc.

• Examples of formulas include summing a rang...read more

Recreating a Power BI report with DAX function and proper visual.

• Understand the data model and relationships in the original report.

• Identify the DAX functions used in the original report.

• Create calculated columns and measures using DAX.

• Design appropriate visuals to represent the data effectively.

A bank is a financial institution that accepts deposits from the public and creates credit.

• Banks provide financial services such as loans, credit cards, and savings accounts.

• They also facilitate transactions such as wire transfers and ATM withdrawals.

• Banks generate profit through interest on loans and investments.

• Excel is a spreadsheet software used for data analysis and organization.

• After 5 years, I plan to have gained experience and advanced in my career.

The time I get to resolve a task problem depends on the severity of the issue and the resources available.

• The severity of the issue determines the priority level and the time frame for resolution.

• The resources available, such as technology and personnel, also impact the time frame.

• Communication with stakeholders and team members is crucial to ensure timely resolution.

• Regular progress updates and status reports help manage expectations and ensure accountability.

• Examples: A min...read more

To manage work effectively, prioritize tasks, set goals, create a schedule, delegate when necessary, communicate clearly, and adapt to changes.

• Prioritize tasks based on importance and deadlines

• Set specific, achievable goals to stay focused

• Create a schedule or to-do list to organize tasks

• Delegate tasks to team members when overwhelmed

• Communicate clearly with team members and supervisors

• Adapt to changes in priorities or deadlines

VLOOKUP and PivotTable are two powerful features of Excel used for data analysis and manipulation.

• VLOOKUP is a function used to search for a specific value in a table and return a corresponding value from the same row.

• PivotTable is a tool used to summarize and analyze large amounts of data in a table format.

• VLOOKUP can be used in conjunction with PivotTable to extract specific data from a larger dataset.

• For example, VLOOKUP can be used to extract customer information from a s...read more

Google Sheets is a cloud-based spreadsheet program while Excel is a desktop-based spreadsheet program.

• Google Sheets is free to use while Excel requires a license.

• Google Sheets can be accessed from anywhere with an internet connection while Excel is limited to the device it is installed on.

• Google Sheets allows for real-time collaboration while Excel requires files to be shared and merged.

• Excel has more advanced features and functions than Google Sheets.

• Google Sheets has built-...read more

I know various advanced Excel formulas like VLOOKUP, INDEX-MATCH, SUMIFS, COUNTIFS, IFERROR, etc.

• VLOOKUP: Searches for a value in the first column of a table and returns a value in the same row from another column.

• INDEX-MATCH: Combination of INDEX and MATCH functions to perform a lookup that VLOOKUP can't handle.

• SUMIFS: Adds the cells specified by a given set of conditions or criteria.

• COUNTIFS: Counts the number of cells that meet multiple criteria.

• IFERROR: Returns a custom r...read more

Yes, Tally is a popular accounting software used by businesses for financial management.

• Tally is used for accounting, inventory management, payroll, and taxation

• It is widely used in India and other countries

• Tally has various versions like Tally.ERP 9, TallyPrime, Tally.ERP 7, etc.

• It has features like GST compliance, bank reconciliation, and invoicing

• Tally can be customized as per the business needs

Yes, I have basic knowledge of computers and am proficient in using PowerPoint.

• I have experience using various computer programs and software.

• I am comfortable navigating through different operating systems.

• I have created presentations using PowerPoint for school projects and work presentations.

This question is discriminatory and irrelevant to my skills and qualifications.

• I believe that my skills and qualifications should be the primary factor in my hiring process.

• My religion or any other personal characteristic should not be a factor in my employment.

• As an MIS executive, my expertise in managing information systems and technology is what should be evaluated.

• This question is discriminatory and irrelevant to my skills and qualifications.

• I would appreciate it if we co...read more

Google Sheets can be created by accessing Google Drive and selecting 'New' and then 'Google Sheets'.

• Access Google Drive

• Click on 'New'

• Select 'Google Sheets'

Option Explicit forces explicit declaration of all variables in a script, while Option Base sets the default lower bound for array subscripts.

• Option Explicit ensures all variables are declared before use to avoid runtime errors.

• Option Base sets the default lower bound for array subscripts, usually 0 or 1.

• Example: Option Explicit Dim x As Integer x = 5

• Example: Option Base 1 Dim arr(5) As Integer

The question is about testing Excel skills using various formulas and tools.

• VLOOKUP formula is used to search for a specific value in a table and return a corresponding value from another column.

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

• SUMIF formula is used to add up values in a range that meet a certain criteria.

• COUNTIF formula is used to count the number of cells in a range that meet a certain criteria.

• Conditional formatting is used to highlight ...read more

HLOOKUP is used to search for a value in the top row of a table and return a corresponding value in the same column from a specified row.

• Identify the top row of the table where you want to search for a value

• Specify the row number from where you want to return the corresponding value

• Use the HLOOKUP function with the lookup value, table array, row number, and range lookup parameters

• Example: =HLOOKUP(A2, B1:E4, 3, FALSE) will search for the value in cell A2 in the top row of the...read more

Index and match functions in Excel are used to lookup values in a table, while joins and diffs in SQL are used to combine and compare data from different tables.

• Index and match functions in Excel are used to search for a value in a table based on row and column headers.

• Joins in SQL are used to combine data from two or more tables based on a related column between them.

• Diffs in SQL are used to compare data between two tables and identify the differences.

• Group in SQL is used to...read more

Procurement and storage of inventory refers to the process of acquiring and storing goods for future use or sale.

• Procurement involves identifying the need for inventory, selecting suppliers, negotiating prices, and placing orders.

• Storage involves determining the appropriate storage conditions, organizing inventory, and tracking inventory levels.

• Effective procurement and storage practices can help minimize costs, reduce waste, and ensure timely availability of inventory.

• Exampl...read more

Yes, I am proficient in both MS Excel and PowerPoint.

• I have experience in creating spreadsheets, using formulas and functions, and analyzing data in Excel.

• I am skilled in creating professional presentations with animations, graphics, and multimedia in PowerPoint.

• I have used both programs extensively in my previous roles and am comfortable with their features and functionalities.

A Pivot table is a data summarization tool used in spreadsheet programs. It allows you to quickly summarize and analyze large amounts of data.

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

• They allow you to quickly create reports and analyze data in different ways

• You can use them to group data by different categories and calculate totals and averages

• Pivot tables are easy to use and can save you a lot of time when working with large data sets

Interacting with daily customers requires active listening, clear communication, and empathy.

• Listen actively to their concerns and needs

• Communicate clearly and concisely

• Show empathy and understanding towards their situation

• Provide helpful solutions and follow up on their concerns

• Maintain a positive and professional attitude

Advance filter is a feature that allows users to apply complex criteria to filter data in a more precise way.

• Advance filter allows users to filter data based on multiple criteria.

• It provides options to filter data using logical operators such as AND, OR, and NOT.

• Users can filter data based on specific values, text, dates, or even formulas.

• Advance filter can be used in various applications like spreadsheets, databases, and data analysis tools.

• Example: Filtering sales data to s...read more

Pivot tables are used to summarize and analyze large datasets. I work with pivot tables by creating them, manipulating them, and using them to draw insights.

• I start by selecting the data I want to analyze and creating a pivot table.

• I then choose the fields I want to include in the table and arrange them as needed.

• I can manipulate the table by adding filters, sorting, and grouping data.

• I use the pivot table to draw insights and make data-driven decisions.

• For example, I might u...read more

Importrange function is used to import data from one Google sheet to another.

• Open the Google sheet where you want to import data

• In a cell, type =importrange("spreadsheet_url", "Sheet1!A1:B10")

• Replace spreadsheet_url with the URL of the sheet you want to import from

• Replace Sheet1!A1:B10 with the range of cells you want to import

• Click enter and grant access to the sheet you want to import from

• Data from the specified range will be imported to the cell where you typed the formula

Ctrl + Alt + V is the shortcut key for inserting Data Validation.

• Press Ctrl + Alt + V to open the Data Validation dialog box.

• Select the type of validation you want to apply.

• Enter the criteria for the validation.

• Click OK to apply the validation to the selected cells.

MS Excel is a spreadsheet software used for data analysis, calculation, and visualization.

• MS Excel is used for organizing and analyzing data

• It can perform complex calculations and create charts and graphs

• It has features like conditional formatting, pivot tables, and macros

• It is widely used in business, finance, and research

• Examples include budgeting, inventory management, and sales analysis

Pressing control + page down will move to the next tab in a browser or spreadsheet.

• Pressing control + page down moves to the next tab in a browser or spreadsheet

• Useful for quickly navigating between multiple tabs or sheets

• Can be used in applications like Excel, Google Sheets, or web browsers

To summarise dealers report in pivot table, select the data and create a pivot table. Choose the relevant fields and summarise data.

• Select the data you want to summarise

• Go to Insert tab and click on Pivot Table

• Choose the relevant fields for Rows, Columns and Values

• Summarise the data using functions like Sum, Count, Average, etc.

• Customise the pivot table as per your requirement