MCQs>Finance & Management>Excel>Functions like MATCH, INDEX, VLOOKUP and HLOOKUP require absolute cell references for the data range. What feature can make those references easier to read and understand?
Excel MCQs
Functions like MATCH, INDEX, VLOOKUP and HLOOKUP require absolute cell references for the data range. What feature can make those references easier to read and understand?
Answer
Correct Answer: Create a name for the data range, and use the name in the formula.
Explanation:
Note: This Question is unanswered, help us to find answer for this one