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

Array Formulas

1 problems

Debug — BYROW Returns Wrong Array Shape

Conditional Formatting

1 problems

Debug — Duplicate Flag Misses Whitespace Variants

Data Cleaning

12 problems

Clean a Roster — TRIM + PROPER

Currency Strings → Numbers

easy

Strip Phone Numbers Down to Digits

Standardize Product Codes — UPPER

Unify Mixed Date Formats to YYYY-MM-DD

Debug — Negatives Lost in SUBSTITUTE Chain

Find the Error — COUNTIF Conflates Case-Distinct Records

Optimize — 5-Deep SUBSTITUTE → REGEXREPLACE

Refactor — Name Parser with LET

Match-Target — Reverse-Engineer the Roster Cleaner

Parse a Single-Column Address into Components

Cross-CRM Deduplication (Case + Whitespace Invariant)

Date Functions

2 problems

Debug — Subscription Renewal Lands a Month BEFORE Start

Find the Error — Tenure Calc Off by One for Leap-Day Hires

IF / Nested IF

12 problems

QA Pass/Fail Flag from a Single Threshold

Bonus Tier from Performance Score

Numeric → Letter Grade Conversion

Shipping Zone from Distance

Progressive Tax Owed by Bracket

Debug — Boundary Misclassification (< vs <=)

Find the Error — Overlapping Conditions, Wrong Order

Optimize — 6-Deep Nested IF → SWITCH (or IFS)

Refactor — Bind a Repeated Subexpression with LET

Match-Target — Reverse-Engineer the Credit Decision Rule

Multi-Axis Discount Engine (Category × Tier × Volume)

Order Disposition Pipeline (4 Rules in Priority Order)

INDEX / MATCH

2 problems

Debug — Lookup Range Drifts on Drag

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

Pivot Fundamentals

2 problems

Debug — Product Pivot Returns Zero for Every Row

Find the Error — "OR" Pivot Double-Counts Overlapping Rows

SUMIF / COUNTIF

2 problems

Debug — SUMIFS Returns Zero on Threshold Criteria

Find the Error — COUNTIFS Reports Zero on Live Customers

Text Functions

2 problems

Debug — First-Word Extractor Includes the Trailing Space

Find the Error — Email Builder Skips a LOWER

VLOOKUP / XLOOKUP

2 problems

Debug — Missing 4th Argument

Find the Error — #N/A Everywhere