Level 1: Newcomer
0 points
Sign in to save your progress across devices.
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.
Speak or type. Sign in to save your results across devices.
Questions are drawn from a bank of 36. Your report includes a skill breakdown and lessons to practice next.
Junior tasks cover the fundamentals. Mid and senior tasks add debugging, changing requirements and review decisions.
10 interviews
Build one net-revenue array in E2 for the service export. Use quantity B, fee C and discount D, and explain the intended spill range.
Build a live invoice action list in E2 for records more than 30 days overdue. Explain how the list updates when source values change.
Build a channel summary in F1 from A1:C7. Return Channel and the summed Amount, ordered by Channel, and explain the grouping grain.
Build a sorted, unique supplier-code list in E2 from A2:A7. Explain whether every export row belongs in the list.
Extract campaign tags into D2:D6. A valid campaign tag has two uppercase letters, a hyphen and three digits.
Split the location in A2 across D2:F2 into Zone, Rack and Bin using its delimiter. Explain how identifiers should be stored.
Return the account tier in D2:D6 from the reference table G2:H5. Explain how you handle the unsorted master.
Calculate the Open backlog value in F2 for the region in F1, using the table A1:D7.
Count Open cases at the 14-day service threshold in E2. State whether you interpret that threshold as inclusive.
Review the draft branch margin calculation in E2 and explain whether the row percentages support a portfolio conclusion.
The Interview Hub is included in All Access. Choose a plan or sign in to your account to continue.