MCQs > Finance & Management > Excel > Which formula should be used to find the row that 'Steven' appears in and return his phone number? (Sheet contains Names in Column A and Phone Numbers in Column B)

Excel MCQs

Which formula should be used to find the row that "Steven" appears in and return his phone number? (Sheet contains Names in Column A and Phone Numbers in Column B)

Answer

Correct Answer: =VLOOKUP("Steven",A:B,2,FALSE)

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