In cell C2, how would you limit the user to choosing one of the company’s five regions(East, Central, North, South, West)?

  • Use reference tabs to create a drop-down list
  • Use a PivotTable slicer to create a drop-down list
  • Insert a table in the data to create a drop-down list
  • Use data validation to create a drop-down list

The correct answer is:

  • Use data validation to create a drop-down list

🎓 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