How to use pivot table , hlookup and vlookup , solved a problem in the interview

Question

Accepted Answer

Pivot tables, HLOOKUP, and VLOOKUP are powerful tools in Excel for analyzing data and finding specific information.

Use pivot tables to summarize and analyze large amounts of data by organizing it into a more manageable format.
HLOOKUP 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.
VLOOKUP 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.
For example, you can use a pivot table to analyze sales data by region, HLOOKUP to find the price of a specific item in a price list, and VLOOKUP to find a customer's information based on their ID.

Popular interview questions of Accounts Analyst