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

Excel Skill Assessment

Overall Skill Level-Poor

Your Skill Level: Poor

Retake Quizzes to improve it

search

Excel Skill Assessment

Overall Skill Level-Poor

Your Skill Level: Poor

Retake Quizzes to improve it