When do you use pivot table, vlookup, hlookup, xlookup?

Question

Accepted Answer

Pivot table for summarizing data, vlookup for finding values in a table, hlookup for horizontal lookup, xlookup for advanced lookup.

Pivot table is used to summarize and analyze large datasets.
VLOOKUP is used to find a value in a table by row.
HLOOKUP is used to find a value in a table by column.
XLOOKUP is a more advanced version of VLOOKUP and HLOOKUP, allowing for more flexibility in searching for data.
Example: Use pivot table to summarize sales data, VLOOKUP to find a customer's information in a table, HLOOKUP to find a product's price in a table, XLOOKUP to search for data in multiple columns.

Top Walmart Catalog Analyst interview questions & answers