EA Table Analysis 1 — Questions and Answers
Question 1: A table lists 5 employees with columns: Name, Department, Salary, Years. Sorted by Salary descending, who appears third?
- The employee with the third highest salary
- The employee with the third lowest salary
- The employee with the median salary (Correct answer)
- The most recently hired employee
Correct answer: The employee with the median salary
When sorted descending, the third row has the third highest salary, which equals the median salary in a 5-row table.
Question 2: A sales table shows: Region A=$500K, B=$300K, C=$400K, D=$200K, E=$600K. Which filter would show only regions above the average?
- Salary > $500K
- Revenue > $400K (Correct answer)
- Revenue >= $500K
- Revenue > $399K
Correct answer: Revenue > $400K
Average = $2,000K / 5 = $400K; filtering for revenue > $400K shows Regions A ($500K) and E ($600K).
Question 3: A product table has columns: Product, Cost, Price, Units Sold. If sorted by Profit Margin (Price−Cost)/Price, which type of product ranks highest?
- Highest price product
- Product with greatest absolute profit
- Product with best (Price−Cost)/Price ratio (Correct answer)
- Product with most units sold
Correct answer: Product with best (Price−Cost)/Price ratio
Sorting by profit margin ranks products by (Price−Cost)/Price, regardless of price level or units sold.
Question 4: A table shows test scores for 6 students. Three scored above 80 and three scored below 70. There are no scores between 70 and 80. What must be true if sorted ascending?
- Scores 4 and 5 are above 80.
- The median score is between 70 and 80.
- Scores 1, 2, 3 are below 70 and 4, 5, 6 are above 80. (Correct answer)
- The mean equals the median.
Correct answer: Scores 1, 2, 3 are below 70 and 4, 5, 6 are above 80.
Ascending sort places the three sub-70 scores in positions 1–3 and the three above-80 scores in positions 4–6.
Question 5: A quarterly budget table has a column 'Variance %' = (Actual−Budget)/Budget. A row with Variance % = −12% means what?
- Actual was 12% over budget.
- Actual was 12% under budget. (Correct answer)
- Budget was 12% more than actual.
- The variance is favorable for a revenue line.
Correct answer: Actual was 12% under budget.
A negative variance percentage means actual fell 12% short of the budget target.
Question 6: A headcount table shows 8 departments. Filtering for departments with headcount > 50 AND budget > $1M returns 3 departments. What is the minimum number of departments that satisfy at least one condition?
- 3
- At least 3 (Correct answer)
- Exactly 5
- Cannot exceed 8
Correct answer: At least 3
The 3 departments satisfy both conditions; additional departments may satisfy one but not both, so at minimum 3 satisfy at least one condition.
EA Table Analysis 1
A table lists 5 employees with columns: Name, Department, Salary, Years.
Sorted by Salary descending, who appears third?