ACT Fibernet Data Analyst Interview Questions and Answers

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 to find and retrieve data from large datasets.

• The function requires a lookup value, a table range, and the column index number.

• Vlookup can be used to perform approximate or exact matches.

• It is often used for data analysis, data validation, and d...read more

A pivot table is a data summarization tool used in spreadsheet programs like Excel.

• It allows users to quickly summarize and analyze large amounts of data.

• Users can easily group data by different categories and perform calculations on them.

• Pivot tables are useful for creating reports and visualizations.

• They can help identify trends and patterns in data.

• Example: A pivot table can be used to summarize sales data by produc

There are two types of Vlookup: Exact Match and Approximate Match.

• Exact Match Vlookup searches for an exact match of the lookup value in the first column of the table array.

• Approximate Match Vlookup searches for an approximate match of the lookup value in the first column of the table array.

• Exact Match Vlookup is denoted by 0 or FALSE in the formula, while Approximate Match Vlookup is denoted by 1 or TRUE in the formul

Filters can be applied to rows in a table to display specific data.

• Select the row(s) you want to filter

• Click on the filter icon in the toolbar

• Choose the filter criteria and apply

• The table will display only the rows that meet the filter criteria