Table Analysis Flashcards

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:

Answer: Had the highest total annual sales.

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

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?

Answer: 15%

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

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?

Answer: Those rows represent net losses (negative net income).

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

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

Answer: Standard deviation of annual growth rates ascending

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

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?

Answer: 4

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

A project timeline table lists Start Date, End Date, and Duration (days). If sorted by Duration ascending, the first project has Start=Jan 1 and End=Jan 8. What is its duration?

Answer: 7 days

Duration = End Date − Start Date = Jan 8 − Jan 1 = 7 days.