USING MICROSOFT EXCEL
HOW TO ADD COPY AND MOVE WORKSHEETS WITHIN EXCEL WORKBOOKS
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
Tom wants to search his spreadsheet for a value in the fourth row of his table. What function should he use?
|
|
VLOOKUP
|
|
|
HLOOKUP
|
|
|
LOOKUP
|
|
|
SEARCH
|
Explanation:
Detailed explanation-1: -VLOOKUP Formula The VLOOKUP function uses the following arguments: Lookup value (required argument) – Lookup value specifies the value that we want to look up in the first column of a table.
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.
There is 1 question to complete.