What is the purpose of the Excel function "VLOOKUP"?

Microsoft Word (38) Microsoft Excel (22) Microsoft PowerPoint (23) Microsoft Access (5) HTML (61) Comptuer Hardware (37) Operating System (25) TSC (50) Software Engineering (4) Computer Network (11)

Microsoft Excel

What is the purpose of the Excel function "VLOOKUP"?

To vertically align text in cells
To search for a value in a table and return a corresponding value from another column
To create a virtual table
To calculate the sum of values in a column

333

Answer : B) To search for a value in a table and return a corresponding value from another column

The VLOOKUP function in Excel is used to search for a specific value in a table and retrieve a corresponding value from another column.

Join Discussion

Comment *

Please Login to Post a Comment

Sign in with Google

RELATED MCQS

What function is used to round a number up to the nearest integer greater than or equal to that number?

In Excel, what does the "Fill Handle" refer to?

Which Excel feature allows you to create a visual representation of your data using bars or columns to represent values?

Which Excel function is used to count the number of cells that meet multiple criteria?

Which of the following is the file extension of Microsoft Excel ?

Which Excel function is used to combine text from multiple cells into one cell?

What does the "AutoSum" feature in Excel do?