Examkin

Question

Difficulty: EasyConditional Filtering and Selection

The table below displays performance metrics for six employees at a technology firm:

EmployeeDepartmentExperience (Years)Completed Projects
AlexMarketing412
BiancaSales615
CarlosMarketing58
DianaEngineering314
EvanSales710
FionaMarketing818

How many employees work in the Marketing department AND have completed more than 10 projects?

  1. A
    1
  2. 2Answer
  3. C
    3
  4. D
    4
  5. E
    5

Answer

2 employees meet both conditions.
To satisfy the criteria, an employee must meet both conditions: Department must be 'Marketing' AND Completed Projects must be strictly greater than 10. Evaluating each employee: Alex (Marketing, 12 projects) meets both conditions; Carlos (Marketing, 8 projects) fails the project threshold; Fiona (Marketing, 18 projects) meets both conditions. No other employees belong to Marketing. Thus, exactly 2 employees qualify.

Step-by-Step Solution

1
Identify the multi-column filter criteria from the question stem.
The criteria require Department = 'Marketing' AND Completed Projects > 10.
Both conditions must be simultaneously true for an employee to qualify.
2
Evaluate each row against both conditions.
- Alex: Marketing (Yes), 12 Projects > 10 (Yes) → Qualifies
- Bianca: Sales (No), 15 Projects > 10 (Yes) → Does not qualify
- Carlos: Marketing (Yes), 8 Projects > 10 (No) → Does not qualify
- Diana: Engineering (No), 14 Projects > 10 (Yes) → Does not qualify
- Evan: Sales (No), 10 Projects > 10 (No) → Does not qualify
- Fiona: Marketing (Yes), 18 Projects > 10 (Yes) → Qualifies
Systematic row-by-row verification prevents missed criteria.
3
Count the qualifying rows.
Alex and Fiona qualify, giving a total count of 2.
Only rows satisfying both conditions are included in the final sum.

Key Concept

Conjunctive (AND) Multi-Column Table Filtering
Rate this question

Topics

Conditional Filtering and Selection

More questions from this topic