USING MICROSOFT EXCEL
HOW TO ADD COPY AND MOVE WORKSHEETS WITHIN EXCEL WORKBOOKS
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
AVERAGEIF
|
|
VLOOKUP
|
|
MID
|
|
HLOOKUP
|
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.