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]
Argument in both the VLOOKUP and HLOOKUP function syntax refers to the range in which you want to look up data. Hint:it is arranged in rows and columns
A
Table Array
B
Spreadsheet
C
Table Set
D
Table Range
Explanation: 

Detailed explanation-1: -The table array argument is always the second argument in a VLOOKUP or HLOOKUP function (the first is the value you’re trying to find), and the functions won’t work without it. Your first argument, the value you want to find, can be a specific value such as “41” or “smith, ” or it be a cell reference such as F2.

Detailed explanation-2: -The formula of VLOOKUP=VLOOKUP (lookup value, table array, col index number, [range lookup]) and the formula of HLOOKUP is =HLOOKUP (lookup value, table array, row index number, [range lookup]). If you notice closely, you may see only one difference between these formulas: row and column.

Detailed explanation-3: -VLOOKUP allows you to search a data range that is set up vertically. HLOOKUP is the exact same function, but looks up data that has been formatted by rows instead of columns. LOOKUP and related functions are commonly used for business analytics in Excel as a way of slicing and dicing data for analysis.

Detailed explanation-4: -The range lookup argument of the VLOOKUP and HLOOKUP functions is the range of values to be looked up in order to determine the function’s result.

There is 1 question to complete.
Previous
Next