200+ MIS Executive Interview Questions and Answers

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

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

Yes, I am ready to move around all India with you.

• I am willing to travel extensively for work.

• I have experience working in different locations.

• I am adaptable and can easily adjust to new environments.

• I understand the importance of being flexible and mobile in a role like this.

• I am excited about the opportunity to explore different parts of India.

A workbook is a file containing multiple worksheets, which are individual pages for data organization in spreadsheet applications.

• A workbook can contain multiple worksheets, e.g., 'Sales Data', 'Inventory', 'Budget'.

• Each worksheet is a single tab within the workbook, allowing for separate data sets.

• Workbooks are saved with extensions like .xlsx or .xls, while worksheets are the individual sheets within them.

• You can reference data from one worksheet in another within the same ...read more

The interviewer asked about Vlookup with match function, transpose without using mouse, conditional formatting, and Sumifs.

• Vlookup with match function is used to search for a specific value in a table and return a corresponding value.

• Transpose without using mouse can be done by using the TRANSPOSE function or by copying and pasting with the transpose option.

• Conditional formatting is used to format cells based on certain conditions, such as highlighting cells that contain a ce...read more

I have a strong understanding of Ms-Excel and its various features.

• Proficient in creating and formatting spreadsheets

• Skilled in using formulas and functions for data analysis

• Experienced in creating charts and graphs for data visualization

• Knowledgeable in data sorting, filtering, and conditional formatting

• Familiar with pivot tables and data consolidation

• Capable of creating macros for automation

• Adept at data validation and protection

• Experienced in importing and exporting data f...read more

I use various commands in Excel depending on the task at hand.

• I use SUM, AVERAGE, MAX, and MIN for basic calculations.

• I use VLOOKUP and HLOOKUP for searching and retrieving data.

• I use IF and COUNTIF for conditional formatting and counting data.

• I use CONCATENATE for combining data from different cells.

• I use FILTER and SORT for organizing and analyzing data.

• I use PIVOT TABLES for summarizing and visualizing data.

• I use macros for automating repetitive tasks.

• I use conditional for...read more

Yes, I am familiar with advanced Excel.

• I have extensive experience in using advanced Excel functions such as VLOOKUP, INDEX-MATCH, and PivotTables.

• I am proficient in creating complex formulas and macros to automate tasks and improve efficiency.

• I have worked with large datasets, using Excel's data analysis tools to extract insights and generate reports.

• I am skilled in data visualization techniques, creating charts and graphs to present information effectively.

• I have also used ...read more

Pivot, vlookup, Hlookup, xlookup, countif are Excel functions used for data analysis and manipulation.

• Pivot tables summarize and analyze large datasets

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

• Hlookup searches for a value in the first row of a table and returns a corresponding value in the same column

• Xlookup is a newer function that can search for values in any column and return a corresponding value

• Countif counts the number of cells in a range ...read more

To create vlookup in another worksheet, use the formula =VLOOKUP(lookup_value, table_array, col_index_num, range_lookup) and specify the sheet name in the table_array argument.

• Open the worksheet where you want to create the vlookup formula

• Click on the cell where you want to display the result of the vlookup formula

• Type the formula =VLOOKUP(lookup_value, table_array, col_index_num, range_lookup)

• Specify the lookup_value, table_array, col_index_num, and range_lookup arguments

• In ...read more

VLOOKUP is a function in Excel that allows you to search for a value in a column and return a corresponding value from another column.

• VLOOKUP stands for vertical lookup.

• It is commonly used to find specific data in large datasets.

• The formula takes 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.

• VLOOKUP is u...read more

Yes, V Lookup & H Lookup are Excel functions used to search for specific data in a table.

• V Lookup searches for a specific value in the first column of a table and returns a corresponding value in the same row from a specified column.

• H Lookup searches for a specific value in the first row of a table and returns a corresponding value in the same column from a specified row.

• Both functions are commonly used in data analysis and can save time when working with large datasets.

The fundamental principles of making FPOs

• FPO stands for Follow-on Public Offering

• The main principle is to offer additional shares of a company to the public after its initial public offering (IPO)

• FPOs are used to raise additional capital for the company

• The pricing of FPO shares is determined based on market demand and company valuation

• FPOs require regulatory approvals and compliance with securities laws

• FPOs can be made through underwriters or directly by the company

• FPOs provi...read more

The main purpose of the work is to ensure efficient and effective use of information technology to support business operations.

• To manage and maintain the organization's information systems

• To analyze and interpret data to provide insights for decision-making

• To identify and implement new technologies to improve business processes

• To ensure data security and privacy

• To provide technical support to end-users

• To collaborate with other departments to align IT strategies with business ...read more

My expected CTC is negotiable and depends on the overall compensation package offered by the company.

• My expected CTC is based on my qualifications, experience, and the responsibilities of the role.

• I am open to discussing the CTC during the interview process.

• I am looking for a competitive salary that aligns with industry standards.

• I am also considering other benefits such as health insurance, retirement plans, and bonuses.

• I am flexible and willing to negotiate based on the ove...read more

Yes, I am proficient in Microsoft Excel and its major tools.

• I am skilled in using Excel functions such as VLOOKUP, SUMIF, COUNTIF, etc.

• I can create and format charts, pivot tables, and graphs.

• I am familiar with data analysis tools like Solver and Goal Seek.

• I can use macros to automate repetitive tasks.

• I have experience in using Excel for financial modeling and forecasting.

• I am comfortable working with large datasets and can use filters and sorting to analyze data efficiently.

MIS is a system that helps organizations make informed decisions by providing timely and relevant information.

• MIS collects, processes, stores, and distributes information to support decision-making in an organization.

• It helps in planning, controlling, and decision-making processes at various levels of an organization.

• MIS provides reports, summaries, and dashboards to help managers monitor performance and identify trends.

• Examples of MIS include sales reports, inventory managem...read more

Countif formula is used to count the number of cells in a range that meet a specific condition.

• Syntax: =COUNTIF(range, criteria)

• Range can be a single cell or a range of cells

• Criteria can be a number, text, cell reference, or expression

• Examples: =COUNTIF(A1:A10,">50") will count the number of cells in range A1:A10 that are greater than 50

• =COUNTIF(B1:B10,"apples") will count the number of cells in range B1:B10 that contain the word "apples"

The function used to calculate weighted product is the SUMPRODUCT function.

• The SUMPRODUCT function multiplies corresponding components in the given arrays and returns the sum of those products.

• It is commonly used in financial analysis, inventory management, and supply chain optimization.

• Example: =SUMPRODUCT(A1:A3, B1:B3) will calculate the weighted product of values in cells A1 to A3 and B1 to B3.

To create a pivot table, select the data range and go to Insert tab > PivotTable.

• Select the data range

• Go to Insert tab > PivotTable

• Choose the location for the pivot table

• Drag and drop the fields into the Rows, Columns, and Values areas

• Apply filters and formatting as needed

Using INDEX-MATCH function and replacing date format in Excel sheet.

• Use INDEX-MATCH function to lookup values in a table

• Syntax: =INDEX(array, MATCH(lookup_value, lookup_array, [match_type]))

• Replace date format using the Format Cells option

• Select the cell(s) with the date, right-click and select Format Cells

• Choose the desired date format from the Number tab

Conditional formatting is a feature in spreadsheet applications that allows users to apply formatting based on certain conditions.

• It allows users to highlight cells that meet specific criteria

• It can be used to color-code data based on values or ranges

• It can also be used to apply different font styles or borders based on conditions

• Examples include highlighting cells with values above a certain threshold or cells that contain specific text

Countif/Sumif/Countifs are Excel functions used to count or sum values based on specified criteria.

• Countif counts the number of cells in a range that meet a given criteria.

• Sumif sums the values in a range that meet a given criteria.

• Countifs counts the number of cells in a range that meet multiple criteria.

• These functions are commonly used in data analysis and reporting.

• Example: Countif(A1:A10,">=5") will count the number of cells in the range A1:A10 that are greater than or e...read more

VLOOKUP and HLOOKUP are functions in Excel used to search for a value in a table and return a corresponding value.

• VLOOKUP stands for vertical lookup and is used to search for a value in the leftmost column of a table and return a value from a specified column in the same row.

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

• Both functions are commonly used for data analys...read more

I have a strong technical knowledge about tiles including types, materials, installation methods, and maintenance.

• Types of tiles: ceramic, porcelain, glass, natural stone, etc.

• Materials used in tiles: clay, sand, glass, etc.

• Installation methods: adhesive, mortar, grout, etc.

• Maintenance techniques: cleaning, sealing, repairing, etc.

The excel sheet contains multiple questions and has a time limit of 39 minutes for completion.

• Read each question carefully before answering.

• Manage your time effectively to ensure all questions are completed within the time limit.

• Double-check your answers before submitting to avoid errors.

• Utilize any available resources or tools to assist in answering the questions.

• Seek clarification on any unclear questions to ensure accurate responses.

Yes, I have knowledge of typing in English.

• I am proficient in typing with a speed of 60 words per minute.

• I have experience in typing official documents, emails, and reports.

• I am familiar with keyboard shortcuts and can use them efficiently.

• I have completed a typing course and received a certificate for the same.

Google Sheets is a web-based spreadsheet program that allows users to create, edit, and collaborate on spreadsheets online.

• Google Sheets is part of the Google Drive suite of productivity tools.

• It offers features like formulas, charts, conditional formatting, and data validation.

• Multiple users can work on the same spreadsheet simultaneously and see real-time changes.

• It can be accessed from any device with an internet connection.

• Google Sheets supports importing and exporting da...read more

Vlookup, index & match, if, countif, sumif are basic Excel functions used for data analysis and manipulation.

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

• Index & match is an alternative to vlookup that allows for more flexibility in selecting columns and rows.

• If function is used to test a condition and return one value if the condition is true and another value if it is false.

• Countif function is used to count t...read more

Current CTC is INR 8 LPA and expected CTC is INR 10 LPA.

• Current CTC: INR 8 LPA

• Expected CTC: INR 10 LPA

I expect a salary that is commensurate with my skills and experience.

• I am open to negotiation based on the job requirements and responsibilities.

• I have researched the industry standards and salary ranges for this position.

• I am looking for a fair and competitive salary package that includes benefits and perks.

• I am more interested in the growth opportunities and learning potential of the job than just the salary.

• I am willing to discuss the salary in detail during the interview ...read more

The selective tool is highly efficient in performing specific tasks.

• The selective tool is designed to perform specific tasks with high accuracy and speed.

• It is efficient in filtering and sorting data based on specific criteria.

• For example, a selective tool can be used to extract data from a large database based on certain parameters.

• It can also be used to automate repetitive tasks, saving time and increasing productivity.

Testing in Microsoft Excel involves verifying the functionality, accuracy, and reliability of formulas, macros, data validation, and other features.

• Test formulas by inputting different values and checking the calculated results.

• Verify the accuracy of macros by running them and comparing the expected outcomes.

• Test data validation rules by entering valid and invalid data to ensure proper validation.

• Check the reliability of features like sorting, filtering, and conditional forma...read more

KAUSHAL BHARAT Portal is a platform for skill development and employment opportunities in India.

• It is an initiative of the Ministry of Skill Development and Entrepreneurship.

• It aims to provide a common platform for job seekers, employers, and training providers.

• It offers various courses and certifications to enhance skills and employability.

• It also provides information on job fairs, apprenticeships, and other employment opportunities.

• It is a part of the larger Skill India Mis...read more

I have 3 years of experience creating dashboards using tools like Tableau and Power BI. Proficient in writing complex SQL queries.

• Experience creating interactive dashboards for tracking key performance indicators

• Proficient in SQL for data extraction, transformation, and analysis

• Used Tableau to visualize data and create actionable insights

• Experience with Power BI for creating dynamic reports and visualizations

I have a strong understanding of advanced Excel functions and features.

• Proficient in using formulas, functions, and data analysis tools in Excel

• Skilled in creating complex spreadsheets and automating tasks using macros

• Experienced in data visualization and creating interactive dashboards

• Familiar with advanced features like pivot tables, conditional formatting, and VBA programming

• Have successfully used Excel for financial analysis, data modeling, and reporting

Vlookup searches for a value in the first column of a table and returns a corresponding value in the same row. Index-Match uses the Index and Match functions to perform the same task.

• Vlookup is simpler to use but has limitations in terms of flexibility.

• Index-Match is more complex but can handle more complex data sets.

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

• Index-Match can search for values in any column of a table.

• Vlookup can only return a value from...read more

A bank is a financial institution that accepts deposits from customers and uses those funds to make loans and investments.

• Banks earn money through interest charged on loans and credit cards

• They also earn money through fees for services such as ATM withdrawals and overdraft protection

• Banks may invest in stocks, bonds, and other financial instruments to earn additional income

• Some banks also offer investment services to customers, earning fees for managing their portfolios

Weekly, monthly, and quarterly reports can be created by collecting relevant data, analyzing it, and presenting key findings in a structured format.

• Gather data from various sources such as databases, spreadsheets, and software systems.

• Analyze the data to identify trends, patterns, and key performance indicators.

• Create visualizations such as charts, graphs, and tables to present the data effectively.

• Summarize the findings in a written report, highlighting important insights an...read more

Explaining how to highlight duplicate values using conditional formatting in Excel

• Select the range of cells you want to check for duplicates

• Go to the Home tab and click on Conditional Formatting

• Select Highlight Cells Rules and then Duplicate Values

• Choose the formatting style you want to apply to the duplicate values

• Click OK to apply the formatting

Data analysis for overall Excel sheet involves examining and interpreting data to uncover insights and trends.

• Summarizing data using functions like SUM, AVERAGE, COUNT, etc.

• Creating pivot tables to analyze data from different perspectives.

• Using charts and graphs to visualize trends and patterns in the data.

• Identifying outliers and anomalies in the data.

• Performing regression analysis to understand relationships between variables.

The question is asking for a VBA code to filter data and create a new workbook.

• Use the Autofilter method to filter data based on specific criteria.

• Create a new workbook using the Workbooks.Add method.

• Copy the filtered data to the new workbook using the Copy method.

• Save the new workbook using the SaveAs method.

Yes, I am comfortable using advanced Excel features.

• I am proficient in using functions like VLOOKUP, INDEX-MATCH, and PivotTables.

• I can create complex formulas and macros to automate tasks.

• I have experience in data analysis, visualization, and reporting using Excel.

• I am familiar with advanced charting techniques and data manipulation tools.

Yes, I have advanced knowledge of Excel.

• I am proficient in using advanced functions such as VLOOKUP, INDEX-MATCH, and PivotTables.

• I am skilled in creating complex formulas and macros to automate tasks.

• I have experience in data analysis and visualization using Excel.

• I am familiar with Excel add-ins such as Power Query and Power Pivot.

• I have used Excel for financial modeling, forecasting, and budgeting.

• I am constantly learning and keeping up-to-date with new Excel features and ...read more