DATABASE FUNDAMENTALS
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: -Named ranges are a form of an absolute reference. By naming a range and using that name in a formula or function, we ensure that the reference will not adjust as the formula or function is copied. The syntax of the VLOOKUP function requires the data being looked for to be in the first column of the lookup range.
Detailed explanation-2: -To name a range, first select the range of data and then insert a table to the range, then put a name to the range from the name box on the left-hand side of the window.
There is 1 question to complete.