> > >

Microsoft Office MCQs

In Microsoft Excel 2016, when do we receive a "#Value!" error in the VLOOKUP function?
i) When the "lookup_value" argument is more than 255 characters.
ii) When the "col_index_num" argument contains text.
iii) When the "col_index_num" argument is equal to 0.

Only option i) is correct.

Only options i) and ii) are correct.

Only options ii) and iii) are correct.

All options i), ii) and iii) are correct.

Answer

Correct Answer:

Only options i) and ii) are correct.

Explanation:

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

Microsoft Office Skill Assessment

Your Skill Level: Poor

Retake Quizzes to improve it