Latest:
LinkedIn Microsoft Excel Certification 

Based on the data in columns D,G,H, and K below, what formula will calculate the average compensation for full-time employees who have a job rating of 5?

Editorial Staff
  • =AVERAGEIF(D:D,K2,H:H,5,G:G)
  • =AVERAGEIF(G:G,D:D,K2,H:H,5)
  • =AVERAGEIFS(K2,H:H,5,G:G)
  • =AVERAGEIFS(G:G,D:D,K2,H:H,5)

The correct answer is:

  • =AVERAGEIFS(G:G,D:D,K2,H:H,5)

🎓 Get all the latest and 100% correct LinkedIn Microsoft Excel Skill Quiz Answers

You May Also Like

How do you create a heatmap in a table, such as this one, which is responsive to the values?

Editorial Staff 0

You have a column of dog breeds that are in all capital letters. What function would you use to convert those dog breeds so that only the first letter of each word is capitalized?

Editorial Staff 0

Which feature enables you to quickly sort and reduce data to a subset?

Editorial Staff 0