FUNDAMENTALS OF COMPUTER

DATABASE FUNDAMENTALS

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?
A
Component 1
B
Component 2
C
Component 3
D
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.

There is 1 question to complete.