USING MICROSOFT EXCEL
HOW TO USE THE CONCATENATE FUNCTION IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
An efficient way to search for and insert a value in a cell when the desired value is stored elsewhere in the worksheet or even in a different workbook.
|
|
Lookup Function
|
|
|
Search Function
|
|
|
CONCATENATE Function
|
|
|
None of the above
|
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: -Use VLOOKUP to search one row or column, or to search multiple rows and columns (like a table).
Detailed explanation-3: -VLOOKUP : Vertical lookup. Searches down the first column of a range for a key and returns the value of a specified cell in the row found.
There is 1 question to complete.