FUNDAMENTALS OF COMPUTER

USING MICROSOFT EXCEL

HOW TO ADD COPY AND MOVE WORKSHEETS WITHIN EXCEL WORKBOOKS

 Question [CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
Which of the following functions searches for a value in the first column of Table ____ array and returns a value in the same row from Col ____ index ____ num?
 A AVERAGEIF B VLOOKUP C MID D HLOOKUP
Explanation:

Detailed explanation-1: -Vlookup searches the first column of a list until it finds a match, then it returns the value associated with that item in the specified column. In the table on the right, you would use Vlookup() to lookup the price or the qty in stock for an item youâ€™re searching. The exact name of the item is mandatory.

Detailed explanation-2: -The array form of LOOKUP looks in the first row or column of an array for the specified value and returns a value from the same position in the last row or column of the array. Use this form of LOOKUP when the values that you want to match are in the first row or column of the array.

Detailed explanation-3: -VLOOKUP : Vertical lookup. Searches down the first column of a range for a key and returns the value of a specified cell in the row found.

Detailed explanation-4: -The Microsoft Excel VLOOKUP function does a vertical lookup for a value in the first column in a table, and returns a value from a different column, in the same row, in that table. VLOOKUP function can find exact matches in the lookup column, such as product code, and return its price.

Detailed explanation-5: -Lookup value: Select the cell where search values will be entered. Table array: The table range, including all cells in the table. Col index num: The data which is being looked up.

There is 1 question to complete.