FUNDAMENTALS OF COMPUTER

DATABASE FUNDAMENTALS

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 Excel MATCH function searches for a lookup value in a range of cells and returns the relative position of that value in the range.

Detailed explanation-4: -Use HLOOKUP when your comparison values are located in a row across the top of a table of data, and you want to look down a specified number of rows. Use VLOOKUP when your comparison values are located in a column to the left of the data you want to find. The H in HLOOKUP stands for “Horizontal."

There is 1 question to complete.