FUNDAMENTALS OF COMPUTER

Previous
Next

USING MICROSOFT EXCEL

HOW TO USE THE CONCATENATE FUNCTION IN EXCEL

Question [CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
This function is a lookup functions that can help you locate a specific item or the position of an item in a specified range.Use the ____ function to return a value or the reference to a value in a specified range.
A
INDEX
B
MATCH
C
VLOOKUP
D
HLOOKUP
Explanation: 

Detailed explanation-1: -Use LOOKUP, one of the lookup and reference functions, when you need to look in a single row or column and find a value from the same position in a second row or column. For example, let’s say you know the part number for an auto part, but you don’t know the price.

Detailed explanation-2: -Excel LOOKUP function-vector form. In this context, a vector refers to a one-column or one-row range. Consequently, you use the vector form of LOOKUP to search one row or one column of data for a specified value, and pull a value from the same position in another row or column.

Detailed explanation-3: -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-4: -=VLOOKUP(lookup value, range containing the lookup value, the column number in the range containing the return value, Approximate match (TRUE) or Exact match (FALSE)).

There is 1 question to complete.
Previous
Next