- Count the number of cells
- Searches for a value in a column and returns a value in the same row
- Calculate the average of values
- Sorts data in ascending order
Read More About This Mcq.
The VLOOKUP function in Excel is used to search for a value in the first column of a range
And return a value in the same row from a specified column.
It is commonly used for looking up data in a table or range.