Knowledge about advance excell ? What is V lookup? What is pivot table?

Question

Accepted Answer

Vlookup is a function in Excel used to search for a value in a table and return a corresponding value. Pivot table is a tool used to summarize and analyze data in Excel.

Vlookup stands for 'vertical lookup' and 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.
Pivot table is a data summarization tool in Excel that allows you to reorganize and summarize selected columns and rows of data in a spreadsheet.
Vlookup example: =VLOOKUP(lookup_value, table_array, col_index_num, [range_lookup])
Pivot table example: Select the data range, go to 'Insert' tab, click on 'PivotTable', choose where to place the pivot table, and drag fields into the 'Rows' and 'Values' areas.

Knowledge about advance excell ? What is V lookup? What is pivot table?

Top Aaj Enterprises Outbound Executive interview questions & answers

Popular interview questions of Outbound Executive

Top HR questions asked in Aaj Enterprises Outbound Executive