Management Information System Executive Interview Questions and Answers

I have a good understanding of advanced Excel formulas.

• I am proficient in using functions like VLOOKUP, INDEX-MATCH, SUMIF, COUNTIF, etc.

• I can create complex formulas using logical and mathematical operators.

• I am familiar with array formulas and how to use them.

• I have experience in using Excel's built-in functions and creating custom functions.

• I can use Excel's data analysis tools like PivotTables and PivotCharts.

• I am constantly learning and keeping up with new features and u...read more

Pivot tables are used in Excel to summarize and analyze data, allowing users to reorganize and display information in a more meaningful way.

• Pivot tables help in summarizing large amounts of data quickly and efficiently.

• They allow users to easily rearrange and filter data to analyze trends and patterns.

• Users can create custom calculations and group data based on specific criteria.

• Pivot tables are commonly used in business and finance for budgeting, forecasting, and data analys...read more

Vlookup is a function in Excel used to search for a value in a table and return a corresponding value.

• Vlookup stands for 'vertical lookup'

• It is used to search for a value in the first column of a table and return a value in the same row from a specified column

• Syntax: =VLOOKUP(lookup_value, table_array, col_index_num, [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 in the 3rd column

• Vlookup is ...read more