EA Table Analysis

Question 1

A table lists 5 employees with columns: Name, Department, Salary, Years. Sorted by Salary descending, who appears third?

Accepted Answer

The employee with the median salary

Answer

The employee with the third highest salary

Answer

The employee with the third lowest salary

Answer

The most recently hired employee

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?

Accepted Answer

Revenue > $400K

Answer

Salary > $500K

Answer

Revenue >= $500K

Answer

Revenue > $399K

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?

Accepted Answer

Product with best (Price−Cost)/Price ratio

Answer

Highest price product

Answer

Product with greatest absolute profit

Answer

Product with most 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?

Accepted Answer

Scores 1, 2, 3 are below 70 and 4, 5, 6 are above 80.

Answer

Scores 4 and 5 are above 80.

Answer

The median score is between 70 and 80.

Answer

The mean equals the median.

Question 5

A quarterly budget table has a column 'Variance %' = (Actual−Budget)/Budget. A row with Variance % = −12% means what?

Accepted Answer

Actual was 12% under budget.

Answer

Actual was 12% over budget.

Answer

Budget was 12% more than actual.

Answer

The variance is favorable for a revenue line.

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?

Accepted Answer

At least 3

Answer

3

Answer

Exactly 5

Answer

Cannot exceed 8