EA Table Analysis 1

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

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?

Accepted Answer

Revenue > $400K

Answer

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?

Accepted Answer

Product with best (Price−Cost)/Price ratio

Answer

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?

Accepted Answer

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

Answer

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?

Accepted Answer

Actual was 12% under budget.

Answer

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

EA - Executive Assesment Practice Test

EA - Executive Assesment Practice Test

EA Table Analysis 1