Table Analysis Flashcards

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

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.

A sales table shows: Region A=$500K, B=$300K, C=$400K, D=$200K, E=$600K. Which filter would show only regions above the average?

Answer: Revenue > $400K

Average = $2,000K / 5 = $400K; filtering for revenue > $400K shows Regions A ($500K) and E ($600K).

A product table has columns: Product, Cost, Price, Units Sold. If sorted by Profit Margin (Price−Cost)/Price, which type of product ranks highest?

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.

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?

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.

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

Answer: Actual was 12% under budget.

A negative variance percentage means actual fell 12% short of the budget target.

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?

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.