Computer Aptitude - Microsoft Office (Basics + Functions)
Which MS Excel option allows users to display only records where sales are greater than ₹50,000?
Which MS Excel option allows users to display only records where sales are greater than ₹50,000?
easy Q2 of 15
Step-by-Step Solution
Step 1: Understand the requirement
Only specific rows matching a condition must be shown.Step 2: Match with data display feature
Filter displays rows that meet the given criteria.Final Answer:
Filter → Option B.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 QuestionsMore Computer Aptitude Quizzes