Associate MIS Executive Interview Questions and Answers

Freeze pane is a feature in spreadsheet software that allows the user to lock rows or columns in place while scrolling through the rest of the sheet. Conditional formatting is a tool that allows the user to apply formatting to cells based on specified conditions.

• Freeze pane is used to keep certain rows or columns visible while scrolling through a large spreadsheet.

• It helps in keeping important information, such as headers, always visible.

• For example, if you freeze the top row...read more

Pivot is a function used in data analysis to reorganize and summarize data.

• Pivot is used to transform rows into columns or columns into rows.

• It helps in summarizing data by grouping and aggregating values.

• Pivot is commonly used in spreadsheet software like Microsoft Excel or Google Sheets.

• For example, if you have a table with sales data where each row represents a sale, you can use pivot to create a summary table with columns representing different products and rows represent...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 in the same row from a specified column.

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

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

Advance Excel formula involves complex functions and operations to manipulate data efficiently.

• Use functions like VLOOKUP, INDEX, MATCH, SUMIF, COUNTIF for advanced data analysis

• Learn how to use logical functions like IF, AND, OR for conditional formatting

• Master array formulas for performing calculations on multiple cells at once

• Understand how to use pivot tables for summarizing and analyzing large datasets