USING MICROSOFT EXCEL
USING THE RIGHT LEFT AND MID FUNCTIONS IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
In Excel, suppose cell D4 has the following formula:=VLOOKUP(A4, A10:D12, 5, TRUE) which part is incorrect?
|
|
Component 1
|
|
|
Component 2
|
|
|
Component 3
|
|
|
Component 4
|
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. Table array (required argument) – The table array is the data array that is to be searched.
Detailed explanation-2: -VLOOKUP stands for Vertical Lookup. As the name specifies, VLOOKUP is a built-in Excel function that helps you look for a specified value by searching for it vertically across the sheet.
There is 1 question to complete.