USING MICROSOFT EXCEL
USING THE RIGHT LEFT AND MID FUNCTIONS IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
When creating a VLOOKUP function, the table array area can be pre-named to make it easier to type into the formula. To name this range, you would go to the Formulas tab and select:
|
|
Name Manager
|
|
|
Create from selection
|
|
|
Define name
|
|
|
Data validation
|
Explanation:
Detailed explanation-1: -The named ranges are useful when regularly applying the VLOOKUP formula. Also, it is very helpful if we need to go to different worksheets to select the table array.
Detailed explanation-2: -When you create a VLOOKUP or HLOOKUP function, you enter a range of cells, such as D2:F39. That range is called the table array argument, and an argument is simply a piece of data that a function needs in order to run. In this case, the function searches those cells for the data you’re trying to find.
There is 1 question to complete.