What is Vlookup, Hookup, pivot table and graph, count and countifs in Excel.

Question

Accepted Answer

Vlookup is a function 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 a large dataset.
It requires a lookup value, a table range, and a column index number.
Example: =VLOOKUP(A2, B2:D10, 3, FALSE) will search for the value in A2 within the range B2:D10 and return the value from the third column.
Hookup is not a recognized term in Excel.
Pivot table is a powerful data summarization tool used to analyze and present data in a structured format.
It allows users to group, filter, and calculate data based on different criteria.
Example: Creating a pivot table to summarize sales data by region and product category.
Graphs in Excel are visual representations of data using different chart types.
They help in understanding trends, comparisons, and patterns in the data.
Example: Creating a bar graph to compare sales figures of different products.
Count is a function used to count the number of cells in a range that contain numbers.
Example: =COUNT(A1:A10) will count the number of cells in the range A1:A10 that contain numbers.
Countifs is a function used to count the number of cells in a range that meet multiple criteria.
Example: =COUNTIFS(A1:A10,">5", B1:B10,"<10") will count the cells in the range A1:A10 that are greater than 5 and the cells in the range B1:B10 that are less than 10.

Accepted Answer

What is joins and operator in SQL.

Popular interview questions of Transaction Processing Associate