USING MICROSOFT EXCEL
USING THE UPPER AND LOWER FUNCTIONS IN EXCEL
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
Jill wants to search her spreadsheet for a value in the first column of her table. What function should sheuse?
|
True
|
|
False
|
|
Either A or B
|
|
None of the above
|
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: -Look for a value in a list with formula. To look up a value in a list, you can use the formulas. Select a blank cell you want to put the result, and type this formula =INDEX(A2:C7, MATCH("Orange", A2:A7, 0), 2) into it, and press Enter key.
There is 1 question to complete.