USING MICROSOFT EXCEL
HOW TO ADD COPY AND MOVE WORKSHEETS WITHIN EXCEL WORKBOOKS
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
Retrive the names of workbooks and worksheets
|
|
|
Retrive information according to given criteria
|
|
|
Dynamically change information in different workbooks and worksheets
|
|
|
Retrive information stored in different resources
|
Detailed explanation-1: -Use LOOKUP, one of the lookup and reference functions, when you need to look in a single row or column and find a value from the same position in a second row or column. For example, let’s say you know the part number for an auto part, but you don’t know the price.
Detailed explanation-2: -The VLOOKUP function in Excel is a powerful function used to lookup data in a table organized vertically. It looks down the left column of a range to find a value.
Detailed explanation-3: -The VLOOKUP or Vertical Lookup function is used when data is listed in columns. This function searches for a value in the left-most column and matches it with data in a specified column in the same row. You can use VLOOKUP to find data in a sorted or unsorted table.
Detailed explanation-4: -The Excel LOOKUP function performs an approximate match lookup in a one-column or one-row range, and returns the corresponding value from another one-column or one-row range.