LinkedIn Microsoft Excel Certification 

What is Colors[Inventory] referring to here? =SUMIFS(Colors[Inventory],Colors[Colors],”Orange”)

Editorial Staff
  • the Inventory worksheet in the Colors workbook.
  • the named range Colors[Inventory], which does not use the Format as Table feature.
  • the Inventory column in the Colors table.
  • the Colors worksheet in the Inventory workbook.

The correct answer is:

  • the Inventory column in the Colors table.

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