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

Which function returns the number of characters in a text string in cell A1?

Editorial Staff 0

Column A contains a list of book titles. To ensure that no book title appears more than once, first you select column A. What should you do next?

Editorial Staff 0

To insert a new column to the left of a specific column, right-click the header containing the column’s letter and select _.

Editorial Staff 0