Bird
0
0

Which MS Excel option allows users to display only records where sales are greater than ₹50,000?

easy Q2 of 15
Computer Aptitude - Microsoft Office (Basics + Functions)
Which MS Excel option allows users to display only records where sales are greater than ₹50,000?
ASort
BFilter
CConditional Formatting
DData Validation
Step-by-Step Solution
  1. Step 1: Understand the requirement

    Only specific rows matching a condition must be shown.
  2. Step 2: Match with data display feature

    Filter displays rows that meet the given criteria.
  3. Final Answer:

    Filter → Option B.
  4. Quick Check:

    Non-matching rows are hidden when filters are applied ✅
Quick Trick: Show selected records = Filter.
Common Mistakes:
  • Using Sort instead of Filter.
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