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?

October 30, 2022 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