USING MICROSOFT EXCEL
HOW TO ADD COPY AND MOVE WORKSHEETS WITHIN EXCEL WORKBOOKS
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
lookup ____ value
|
|
|
table ____ array
|
|
|
range ____ lookup
|
|
|
array ____ table
|
Detailed explanation-1: -Answer: C. range lookup argument. Explanation: The “range lookup” argument in the VLOOKUP and HLOOKUP functions can be set to either TRUE or FALSE. If set to TRUE, the function will return the next lower value in the table array if an exact match is not found.
Detailed explanation-2: -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-3: -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]).
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.
Detailed explanation-5: -In simple terms, HLOOKUP function searches horizontally through rows to retrieve data from a specific row in the table. The VLOOKUP, or vertical lookup function, on the other hand, is rather used when data is listed in columns instead of rows.