Bird
0
0

Which MS Excel feature is used to restrict users to enter data only from a predefined list in a cell?

easy Q11 of 15
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?
AData Validation
BConditional Formatting
CFilter
DSort
Step-by-Step Solution
  1. Step 1: Identify the requirement

    The task is to restrict input values to a predefined list.
  2. Step 2: Recall Excel input-control tools

    Data Validation allows rules and drop-down lists for data entry.
  3. Final Answer:

    Data Validation → Option A.
  4. 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 Questions
More Computer Aptitude Quizzes