LinkedIn Microsoft Excel Certification 

Which function, when entered into cell G7, allows you to determine the sum total of annual sles for market regions 18 and greater?

Editorial Staff
  • =SUMIF(G2:G6,”>17″,F2:F6)
  • =SUM(G2:G6,”>=18,F2:F6)
  • =SUMIF(F2:F6,”>=18″,G2:G6)
  • =SUM(F2:F6,”18+”,G2:G6)

The correct answer is:

  • =SUMIF(F2:F6,”>=18″,G2:G6)

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