Fusionnet MIS Executive Interview Questions, Process, and Tips

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

• Vlookup stands for 'Vertical Lookup'

• It is commonly used in Excel to search for a value in the leftmost 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) - searc...read more

Conditional formatting is a feature in software applications that allows users to apply formatting rules to cells or data based on specified conditions.

• Allows users to highlight important information

• Can be used to visually represent data trends

• Helps in quickly identifying outliers or exceptions

• Commonly used in spreadsheet applications like Excel

A Pivot Table is a data summarization tool used in spreadsheet programs to reorganize and summarize selected columns and rows of data.

• Allows users to extract significance from a large, detailed data set

• Can group data by categories and display sums, averages, counts, or other statistics

• Provides a dynamic way to analyze data without altering the original dataset

• Commonly used in Excel, Google Sheets, and other spreadsheet

To create a sales report in a pivot table, you need to organize your sales data and use pivot table tools in Excel.

• Organize your sales data with columns for product, sales amount, date, etc.

• Select your data range and go to Insert > PivotTable in Excel.

• Drag and drop fields like product and sales amount into Rows and Values section of the pivot table.

• Apply filters, group data, and customize the layout to create a compreh...read more