Skip to main content

Problems Pricing Sign In

Practice

Problems

Filter by interview track to focus on the skills that matter for your role.

All Tracks IB Analyst Consulting Case Big 4 Audit FP&A Data Analyst

INDEX / MATCH

12 problems

Product Lookup by SKU

Sector Lookup by Ticker

Manager by Employee ID (Left-Of-Key Lookup)

SKU by Product Name (Right-To-Left Lookup)

Region × Product Price Grid (Two-Way Lookup)

easy

Debug — Lookup Range Drifts on Drag

Find the Error — Off-by-One in 2D INDEX/MATCH/MATCH

Recreate the Revenue Chart — Calendar-Order Monthly Pull

Refactor — INDEX/MATCH/MATCH → INDEX/XMATCH/XMATCH

Optimize — Tier-Band Lookup with Approximate Match

Distinct Campaigns per Region (Array Formula)

Multi-Criteria Budget Lookup

LET / LAMBDA

6 problems

Net Margin via LET-Named Revenue and Cost

First LAMBDA — Define Double(x) Inline

Refactor — Tax-Bracket Calc with LET-Named Thresholds

Optimize — % of Total per Region without Repeating the Range

LAMBDA — FizzBuzz in One Cell

LAMBDA + LET — Tax Bracket Engine via MIN/MAX Clamps

SUMIF / COUNTIF

12 problems

Quarterly Sales by Region

Recreate the Monthly Revenue Chart

Pipeline Total by Sales Stage

Monthly Expense Total by GL Account

Count Present Days from Attendance Log

AR Aging Buckets — Past-Due Counts

Debug — SUMIFS Returns Zero on Threshold Criteria

Find the Error — COUNTIFS Reports Zero on Live Customers

Refactor — Bind the Range Once with LET

SUMIFS vs. SUMPRODUCT — When Each Wins

Distinct Customers per Region (No Helper Column)

Cohort Revenue by Order Month (Multi-Step SUMPRODUCT)

VLOOKUP / XLOOKUP

12 problems

Salary Lookup by Department

Tier-based Per-Seat Pricing

ZIP Code → Delivery Region (Range Lookup)

Vendor Risk Rating Lookup

License Tier — Cost AND SLA

Debug — Missing 4th Argument

Find the Error — #N/A Everywhere

Optimize — One Spilling XLOOKUP

Refactor — Two-Step VLOOKUP → One XLOOKUP

Match the Target — Department-of-Record Codes

Composite-Key Lookup — Region × Tier

Org Chart Traversal — 3 Levels of Chain-of-Command