FUNDAMENTALS OF COMPUTER

Previous
Next

DATABASE FUNDAMENTALS

USING THE RIGHT LEFT AND MID FUNCTIONS IN EXCEL

Question [CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
The Vlookup function is used to find values ​​based on readings in a reference table that is determined based on column nos (data arranged vertically). In Vlookup there is a form of writing, which of the following answers is the correct form of writing Vlookup____
A
=VLOOKUP(Criteria;No ____ Column ____ Table ____ Reference;Rangelookup;Table ____ Reference)
B
=VLOOKUP(Criteria;Table ____ Reference;Rangelookup;No ____ Column ____ Table ____ Reference)
C
=VLOOKUP(Criteria; Rangelookup;Table ____ Reference;No ____ Column ____ Table ____ Reference)
D
=VLOOKUP(Criteria; No ____ Column ____ Table ____ Reference;Table ____ Reference;Rangelookup)
E
=VLOOKUP(Criteria;Table ____ Reference;No ____ Column ____ Table ____ Reference;Rangelookup)
Explanation: 

Detailed explanation-1: -Use VLOOKUP when you need to find things in a table or a range by row. For example, look up a price of an automotive part by the part number, or find an employee name based on their employee ID.

Detailed explanation-2: -The VLOOKUP function consists of three required arguments, in the following order: lookup value, table array, and column index number. The lookup value is the value for which you want to find matching data and must appear in the first column of the lookup table; it can be a value, a text string, or a cell reference.

Detailed explanation-3: -VLOOKUP stands for ‘Vertical Lookup’. It is a function that makes Excel search for a certain value in a column (the so-called ‘table array’), in order to return a value from a different column in the same row.

Detailed explanation-4: -The Col index num (Column index number) is the relative column number in the list. Nothing to do with where it is in Excel, it’s the column number in the table.

There is 1 question to complete.
Previous
Next