Formulas in excel - Vlookup, Hlookup, IF, Sumif, Count, Pivot table

Question

Accepted Answer

Excel formulas like Vlookup, Hlookup, IF, Sumif, Count, Pivot table are used for data analysis and manipulation.

Vlookup is used to search for a value in the first column of a range and return a value in the same row from another column.
Hlookup is similar to Vlookup but searches for a value in the first row of a range and returns a value in the same column from another row.
IF function is used to perform logical tests and return a value based on the result.
Sumif calculates the sum of a range based on a single condition.
Count function counts the number of cells in a range that contain numbers.
Pivot tables are used to summarize and analyze data in a spreadsheet.

Popular interview questions of Analyst