EA Table Analysis 3

Question 1

A sales table has columns: Rep, Region, Q1, Q2, Q3, Q4. Sorting by Q4 descending identifies the top performer in Q4. This does NOT tell you which rep:

Accepted Answer

Had the highest total annual sales.

Answer

Sorting by Q4 alone does not indicate total annual performance, which requires summing all four quarters.

Question 2

A table of 20 job applicants is filtered to show only those with GPA ≥ 3.5, returning 8 applicants. Then filtered further for 5+ years experience, returning 3. What percentage of all applicants meet both criteria?

Accepted Answer

15%

Answer

3 out of 20 applicants = 15% meet both criteria.

Question 3

A financial table shows negative values in red and positive in black. After sorting ascending by Net Income, the first several rows appear in red. What does this indicate?

Accepted Answer

Those rows represent net losses (negative net income).

Answer

Ascending sort places the most negative (lowest) values first; red indicates negative net income, meaning those are net losses.

Question 4

A table shows headcount by year for 5 offices. To find which office had the most consistent growth, an analyst should sort by:

Accepted Answer

Standard deviation of annual growth rates ascending

Answer

Consistency in growth is measured by low variability; sorting by standard deviation ascending puts the most consistent grower at the top.

Question 5

A vendor comparison table has 6 vendors. After filtering for Price < $50, 4 vendors remain. After also filtering for Rating ≥ 4.0, only 2 remain. How many vendors have Price ≥ $50 OR Rating < 4.0?

Accepted Answer

4

Answer

Only 2 vendors satisfy both conditions; the remaining 4 fail at least one — they have Price ≥ $50 or Rating < 4.0.

EA - Executive Assesment Practice Test

EA - Executive Assesment Practice Test

EA Table Analysis 3