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?

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

Ads Blocker Image Powered by Code Help Pro

Ads Blocker Detected!!!

We have detected that you are using extensions to block ads. Please support us by disabling these ads blocker.

Powered By
100% Free SEO Tools - Tool Kits PRO