Multiple choice technology

You want to create a drop down list in a cell, so users can select from a list of products. Which Excel feature should you use?

  1. Pivot Table

  2. AutoFormat

  3. Data Validation

  4. Named Range
Reveal answer Fill a bubble to check yourself
C Correct answer
Explanation

Data Validation is the Excel feature that creates drop-down lists in cells. You specify a list of values (often using a Named Range as the source), and users can only select from that list. Pivot Tables summarize data, AutoFormat changes appearance, and while Named Ranges are often used as the source, they don't create the drop-down themselves.

Keep practicing — related questions