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

Conditional Formatting

6 problems

Flag Overdue Invoices

Highlight the Top 3 Reps by Revenue

Debug — Duplicate Flag Misses Whitespace Variants

KPI Score Color Bands (Green / Yellow / Red)

SLA Escalation Flag (Open + High + Past SLA)

medium

Match-Target — Reverse-Engineer the Ticket Triage Rule

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)

Pivot Fundamentals

12 problems

Order Count by Month

Revenue by Region

Top 3 Products by Units Sold

Headcount by Department

Region × Product Revenue Matrix

Debug — Product Pivot Returns Zero for Every Row

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

Optimize — Monthly Revenue Without a Helper Column

Refactor — Bind Pivot Ranges with LET

Reproduce the Monthly Revenue × Category Chart

Region × Quarter Revenue Aggregate

Cohort Retention — Month-Over-Month Return Rate

Text Functions

12 problems

Pull the Domain Out of an Email Column

Convert Article Titles to URL Slugs

Left-Pad SKU Numbers to 6 Digits

Anonymize Last Names to First-Initial

Split Compound SKU into Four Columns

Debug — First-Word Extractor Includes the Trailing Space

Find the Error — Email Builder Skips a LOWER

Optimize — IF-Chain → TEXTJOIN(ignore_empty)

Refactor — Last-First Builder with LET

Match-Target — Reverse-Engineer the Employee Citation

Pull the Service Name Out of a Pipe-Delimited Log Line

Redact PII (Email + Phone + SSN) From Free Text