FUNDAMENTALS OF COMPUTER

Previous
Next

USING MICROSOFT EXCEL

HOW TO ADD COPY AND MOVE WORKSHEETS WITHIN EXCEL WORKBOOKS

Question [CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
The LookUp function has three arguments. First ____ then data to search and finally, results column
A
Value to Look Up
B
Value to Calculate
C
Either A or B
D
None of the above
Explanation: 

Detailed explanation-1: -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-2: -The VLOOKUP function has the following syntax for its four arguments: VLOOKUP(lookup value, table array, col index num, [range lookup])

Detailed explanation-3: -Lookup value is the value that LOOKUP function searches in an array. It can be a number, text, a logical value, or a name or even a reference to a value. Lookup vector is a range that contains only one row or one column of a text, numbers, or logical values, placed in ascending order.

There is 1 question to complete.
Previous
Next