> > >

Excel MCQs

In the formula "=VLOOKUP(A3,$J$3:$K$12,2,TRUE)", the 4th argument of the VLOOKUP function, "TRUE", indicates

that the table array for the look up has already been validated

to ignore blank values in the index column and return the next value in the index column when a blank is encountered

to only look up values that are greater than zero

to use an exact look up, only returning exact matches to the lookup value

to use a range look up, returning the closest matches to the lookup values

Answer

Correct Answer: to use a range look up, returning the closest matches to the lookup values

Explanation:

Note: This Question is unanswered, help us to find answer for this one

Excel Skill Assessment

Your Skill Level: Poor

Retake Quizzes to improve it