Look up a known margin
What margin belongs to order O-503?
Formula: =XLOOKUP("O-503",A2:A5,D2:D5) → 0.25
Hands-on Excel exercises
Advanced Excel Assessment
Take an advanced Excel assessment with live formula practice, lookup, auditing, analysis, and dashboard tasks plus worked explanations.
An advanced Excel assessment should test decisions, not just function names. Can you inspect unfamiliar data, choose a robust lookup, build a conditional calculation, catch an error without hiding the cause, and explain how you checked the result? The live spreadsheet begins with IFERROR because error handling exposes that judgment: a clean label is useful only after the underlying formula has been verified.
The task set samples lookups, multi-criteria logic, dynamic arrays, auditing, statistics, PivotTables, cleanup, and a dashboard project. Time yourself if you want an interview-style run, but write down assumptions before rushing. For each task, inspect the headers and data types, make a small correct result, and then copy or scale it. A plausible number is not proof; use a second method such as filtering, a check total, or a known record.
This page links heavily to the dedicated Excel interview preparation path, which orders lessons and questions into a fuller study plan. Use this assessment to identify weak areas, then follow that path for deliberate practice. Access badges reflect the current lesson rules, while the live exercise on this page remains free and available without sign-in.
Your turn
Your turn: in F2, return Review when the order ID in E2 is missing.
| A | B | C | D | E | F | |
|---|---|---|---|---|---|---|
| 1 | Order ID | Region | Revenue | Margin | Audit ID | |
| 2 | O-501 | North | 1250 | 0.22 | O-505 | |
| 3 | O-502 | South | 980 | 0.18 | ||
| 4 | O-503 | East | 1430 | 0.25 | ||
| 5 | O-504 | West | 760 | 0.14 |
Not yet solved.
Answer: =IFERROR(XLOOKUP(E2,A2:A5,C2:C5),"Review")
Related exercises
Open a task in its lesson.
- In J2:J4, find the course code by teacher (the code is to the left!). If there is no such teacher, show "No course".
- In F5, find Daniel's largest deal.
- In E7, list the items priced over $300, sorted by price from highest to lowest.
- Fix D5: the number of units of juice sold.
- D2:D7 should hold one formula, Qty × Price, in every row. Find the row where a number was typed in and fix it.
- In F6, find the weakest result with the SMALL function.
- In I15, use a formula to find the name of the top destination in the first PivotTable.
- Build a doughnut chart from E8:F11 and switch the month in F1: the chart changes.
Worked answers
Try the spreadsheet first, then compare your formula and result.
Find the largest order
What is the highest revenue in the order table?
Formula: =MAX(C2:C5) → 1430
Frequently asked questions
What counts as advanced Excel?
Advanced work combines reliable formulas, lookups, cleanup, PivotTables or dynamic arrays, auditing, and clear communication about assumptions.
How should I use this for an interview?
Attempt the tasks without notes, explain your choices aloud, then use the worked answers and interview path to review weak topics.
Does this produce a formal certification?
No. It is a practice assessment and study guide, not a proctored credential or employer-issued test.
Where can I find more interview questions?
Open the linked Excel Interview Preparation path for a structured lesson sequence and role-relevant questions.