Latest:
LinkedIn Microsoft Excel Certification 

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?

Editorial Staff
  • =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

You May Also Like

In the worksheet below, you want to copy the formatting of cell A1 into cells B1:D1. Which approach (see arrows) accomplishes this the most efficiently?

Editorial Staff 0

You want to restrict the values entered in a cell to a specified set, such as Hop, Skip, Jump. Which type of data validation should you use?

Editorial Staff 0

You want to find the second-largest invoice in a column containing all the invoices in a given month. What function would you use?

Editorial Staff 0