Computer Aptitude - Microsoft Office (Basics + Functions)
Which MS Excel feature allows a drop-down list to appear when entering data into a cell?
Which MS Excel feature allows a drop-down list to appear when entering data into a cell?
medium Q6 of 15
Step-by-Step Solution
Step 1: Identify input method
The cell should show selectable options.Step 2: Match with input control tool
Data Validation provides drop-down lists.Final Answer:
Data Validation → Option B.Quick Check:
List-based inputs are created using Data Validation ✅
Quick Trick: Drop-down input = Data Validation.
Common Mistakes:
- Using Filter which works on existing data.
Master "Microsoft Office (Basics + Functions)" in Computer Aptitude
Start learning the concept with an interactive lesson.
Want More Practice?
15+ quiz questions · All difficulty levels · Free
Free Signup - Practice All QuestionsMore Computer Aptitude Quizzes