Excel Interview Test Practice

What you'll build

What you will be able to do

Each lab ends with a concrete result that you build yourself and the checker confirms, cell by cell.

• Suggested time: 10 minutes. You pull prices and regions into an order list, apply a discount tier with an approximate match and read a two-way rate table.
• Suggested time: 10 minutes. From 16 deals you build a region × category revenue grid, count big deals, total a date range and average one rep's deals.
• Suggested time: 10 minutes. You decide for eight reps who hit target, who gets a bonus, which commission tier applies and who is on a commission hold.
• Suggested time: 10 minutes. You calculate shares of total, year-on-year growth and gross margin, then reverse a discount, avoiding the traps tests are built around.
• Suggested time: 10 minutes. You clean a messy CRM export: fix names, flip "Last, First", pull the email domain and build account codes.
• Suggested time: 10 minutes. You work out due dates, days late and payment runs, count project working days around holidays and calculate full years of service.
• Suggested time: 10 minutes. You rebuild a PivotTable with formulas: a region × month grid, totals, % of total, the top region and a COUNTIFS.
• Suggested time: 10 minutes for the order table and 10 minutes for the KPIs. You clean, look up, price and schedule 12 orders, then report three KPIs: eight graded cells, like a real assessment.