FUNDAMENTALS OF COMPUTER

USING MICROSOFT EXCEL

HOW TO USE THE CONCATENATE FUNCTION IN EXCEL

Please wait while the activity loads.
If this activity does not load, try refreshing your browser. Also, this page requires javascript. Please visit using a browser with javascript enabled.

If loading fails, click here to try again

Question [CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]

This function goes down the first column until a match is found and then looks in one of the columns to the right to find the value in the same row?

A	VLOOKUP
B	HLOOKUP
C	CLOOKUP
D	RLOOKUP

Explanation:

Detailed explanation-1: -The VLOOKUP or Vertical Lookup function is used when data is listed in columns. This function searches for a value in the left-most column and matches it with data in a specified column in the same row. You can use VLOOKUP to find data in a sorted or unsorted table.

Detailed explanation-2: -The XLOOKUP function in Excel searches a range or an array for a specified value and returns the related value from another column. It can look up both vertically and horizontally and perform an exact match (default), approximate (closest) match, or wildcard (partial) match.

Detailed explanation-3: -The VLOOKUP function performs a vertical lookup by searching for a value in the first column of a table and returning the value in the same row in the index number position. The VLOOKUP function is a built-in function in Excel that is categorized as a Lookup/Reference Function.

Detailed explanation-4: -The Excel MATCH function searches for a lookup value in a range of cells and returns the relative position of that value in the range.

There is 1 question to complete.