Computer Aptitude - Microsoft Office (Basics + Functions)
Which MS Excel feature is used to restrict users to enter data only from a predefined list in a cell?
Which MS Excel feature is used to restrict users to enter data only from a predefined list in a cell?
easy Q11 of 15
Step-by-Step Solution
Step 1: Identify the requirement
The task is to restrict input values to a predefined list.Step 2: Recall Excel input-control tools
Data Validation allows rules and drop-down lists for data entry.Final Answer:
Data Validation → Option A.Quick Check:
Drop-down lists are created using Data Validation ✅
Quick Trick: Restrict or control input = Data Validation.
Common Mistakes:
MISTAKES- Choosing Filter which only displays data, not restricts input.
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