Latest:
LinkedIn Microsoft Excel Certification 

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

Editorial Staff
  • 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

You May Also Like

You are creating a slide that shows annual rainfall in different regions of Europe. What chart type would most effectively communicate that relationship?

Editorial Staff 0

You want to be able restrict values allowed in a cell and need to create a drop-down list of values from which users can choose. Which feature should you use?

Editorial Staff 0

The AutoSum formulas in the range C9:F9 below return unexpected values. Why is this?

Editorial Staff 0