Which VLOOKUP function, when entered into cell L2 and then dragged to cell L5, returns the average number of calls for the representative IDs listed in column J?
- =VLOOKUP(A2,J2:L5,1,FALSE)
- =VLOOKUP(J2,A$2:C$7,1,FALSE)
- =VLOOKUP(J2,A$2:C$7,3,FALSE)
- =VLOOKUP(J2,A2:C7,3,FALSE)
The correct answer is:
- =VLOOKUP(J2,A$2:C$7,3,FALSE)
🎓 Get all the latest and 100% correct LinkedIn Microsoft Excel Skill Quiz Answers