Excel interviews

Work in the tool while you explain your decisions.

Choose a role and level. Each interview has a new task, follow-up questions and a report that checks your work and your explanation.

Take the assessment Choose an interview

Speak or type. Sign in to save your results across devices.

Timed assessment

12 practical questions
40 minutes
Mid level

Questions are drawn from a bank of 36. Your report includes a skill breakdown and lessons to practice next.

Start assessment

Practice interviews

Junior tasks cover the fundamentals. Mid and senior tasks add debugging, changing requirements and review decisions.

Position

10 interviews

Data analyst
Junior
20 min

Subscription accrual review

Review Alder Quay annual service contracts. Build the recognized revenue schedule in E2:E6 from each contract value and service period. Explain your allocation basis before editing.

Start interview

Skills and rubricRevenue allocation

Produces the requested result and explains the source fields.
Identifies the required output cells or query and preserves the source rows.
Tests a concrete boundary case before reporting a result.

Data analyst
Junior
20 min

Supplier rate reconciliation

Return the approved supplier rate in D2:D6 using the master list in G2:H5. Explain how you match supplier identifiers.

Start interview

Skills and rubricExact lookups and missing keys

Produces the requested result and explains the source fields.
Identifies the required output cells or query and preserves the source rows.
Tests a concrete boundary case before reporting a result.

Accounting analyst
Junior
20 min

Returns summary handoff

Create PivotTable1 at H3 from Work!A1:D7 with Depot in Rows and Amount in Values summarized by Sum. Keep returns and zero transactions.

Start interview

Skills and rubricPivotTable aggregation

Produces the requested result and explains the source fields.
Identifies the required output cells or query and preserves the source rows.
Tests a concrete boundary case before reporting a result.

Data analyst
Mid
25 min

Open invoice screening

Build an overdue invoice exposure total in F2 for invoices more than 30 days overdue. Explain the population behind the total.

Start interview

Skills and rubricMultiple-condition totals

Tests a boundary and handles the revised requirement without hard-coded outputs.
Explains how missing values and duplicate business keys affect this result.
Reconciles the source population and the final output before handoff.

Financial analyst
Mid
25 min

Service threshold debugging

Classify service cases into Within, Watch and Late in D2:D6 using the 24-hour and 48-hour service thresholds. Explain the boundary assumptions before editing.

Start interview

Skills and rubricBoundary conditions

Tests a boundary and handles the revised requirement without hard-coded outputs.
Explains how missing values and duplicate business keys affect this result.
Reconciles the source population and the final output before handoff.

Financial analyst
Mid
25 min

Receipt matching across duplicates

Reconcile receipts in A:B against billed invoices in F:H. Put the unpaid balance beside each invoice in G2:G5 and explain your matching approach.

Start interview

Skills and rubricReconciliation by business key

Tests a boundary and handles the revised requirement without hard-coded outputs.
Explains how missing values and duplicate business keys affect this result.
Reconciles the source population and the final output before handoff.

Operations analyst
Mid
25 min

Imported account code cleanup

Prepare canonical account codes in D2:D6 from the imported values in A. Trim outside spaces and uppercase the result.

Start interview

Skills and rubricText normalization

Tests a boundary and handles the revised requirement without hard-coded outputs.
Explains how missing values and duplicate business keys affect this result.
Reconciles the source population and the final output before handoff.

Financial analyst
Senior
35 min

Portfolio margin audit

Review the draft branch-margin calculation in E2 and explain whether it supports a portfolio decision. Inspect the different branch sizes before proposing a correction.

Start interview

Skills and rubricWeighted margins

Defends the model grain, exposes silent failure modes and gives a maintainable handoff.
States the contract behind each assumption and identifies its business owner.
Discusses refresh or recalculation cost without making unsupported performance claims.

Operations analyst
Senior
35 min

Freight quote matrix

Build a freight quote in D2 for the route in A2 using the Standard service column in the matrix F1:I5. Explain how the matrix lookup works.

Start interview

Skills and rubricTwo-dimensional lookup

Defends the model grain, exposes silent failure modes and gives a maintainable handoff.
States the contract behind each assumption and identifies its business owner.
Discusses refresh or recalculation cost without making unsupported performance claims.

Accounting analyst
Senior
35 min

Month-end revenue cutoff

Build the month revenue total in F2 from posting dates A and amounts B using the month-start controls D2 and E2. State your date cutoff convention.

Start interview

Skills and rubricDate-window aggregation

Defends the model grain, exposes silent failure modes and gives a maintainable handoff.
States the contract behind each assumption and identifies its business owner.
Discusses refresh or recalculation cost without making unsupported performance claims.

Choose your character

Excel interviews

Timed assessment

Practice interviews

Subscription accrual review

Supplier rate reconciliation

Returns summary handoff

Open invoice screening

Service threshold debugging

Receipt matching across duplicates

Imported account code cleanup

Portfolio margin audit

Freight quote matrix

Month-end revenue cutoff

Interview Hub access

Your Work Gym account