EA Table Analysis 2

Question 1

A table of 10 investments shows annual returns from −5% to +18%. If sorted descending by return, how many investments must be examined before finding the first negative return?

Accepted Answer

It depends on the data.

Answer

Without knowing how many investments have positive returns, we cannot determine exactly where the first negative return appears in a descending sort.

Question 2

A supplier table has columns: Supplier, Lead Time, Cost/Unit, Quality Score. A buyer wants the lowest cost among suppliers with Lead Time ≤ 5 days AND Quality Score ≥ 8. This requires filtering on how many columns?

Accepted Answer

2

Answer

The buyer filters on Lead Time and Quality Score (2 columns), then minimizes Cost/Unit within those results.

Question 3

A revenue table shows 12 months of data. The column 'MoM Growth %' is calculated as (This Month − Last Month) / Last Month. January cannot have a MoM Growth % value because:

Accepted Answer

There is no prior month in the dataset.

Answer

MoM growth for January requires December of the prior year, which is not in the 12-month dataset.

Question 4

A table shows project data sorted by 'Priority' (High, Medium, Low). What type of sort is applied to the Priority column?

Accepted Answer

Custom categorical sort

Answer

High/Medium/Low follows a custom categorical order, not alphabetical or numeric ordering.

Question 5

A table has 50 rows. A filter is applied: Region = 'West'. The result shows 15 rows. An analyst then sorts these 15 rows by revenue. How many total rows does the analyst see?

Accepted Answer

15

Answer

Sorting does not add or remove rows; the 15 filtered rows remain, just reordered by revenue.

EA - Executive Assesment Practice Test

EA - Executive Assesment Practice Test

EA Table Analysis 2