Work through a connected business scenario. Each correct answer unlocks the next mission until the case study is complete. Want a different role, difficulty, or time commitment? Browse all challenges.
Case Study
The Ops Handoff
Clean the vendor data, identify the urgent exceptions, and report the spend that still needs action.
Core Skills
Scenario
You are the new Ops Manager at a tech startup. Finance needs you to stabilize the vendor ledger before the Monday leadership review, and every step depends on the last one being finished cleanly.
Current Mission
Clean the vendor name helper column so the ledger is presentation-ready.
What formula should you enter for the first helper-row value to remove extra spaces from the vendor name in row 2?
Dataset
Work from the table below, then submit the formula or result for the current mission.
Vendor Spend Tracker - rows 1-12
Download CSV| Row numbers | A | B | C | D | E |
|---|---|---|---|---|---|
| Header row | |||||
| 2 | INV-1001 | Cloudline Software | Engineering | Paid | $12,500.00 |
| 3 | INV-1002 | Apex Office Supply | Operations | Paid | $487.50 |
| 4 | INV-1003 | Summit Consulting Group | Finance | Paid | $18,750.00 |
| 5 | INV-1004 | Meridian Travel Co. | Sales | Paid | $3,200.00 |
| 6 | INV-1005 | Forge & Frame Creative | Marketing | Paid | $7,600.00 |
| 7 | INV-1006 | NovaTech Solutions | Engineering | Pending | $9,800.00 |
| 8 | INV-1007 | Atlas Hardware Co. | Operations | Paid | $2,150.00 |
| 9 | INV-1008 | Clearview Data Systems | Engineering | Overdue | $15,300.00 |
| 10 | INV-1009 | Redstone Marketing | Marketing | Paid | $4,250.00 |
| 11 | INV-1010 | Keystone Legal Advisors | Finance | Paid | $8,900.00 |
| 12 | INV-1011 | Cloudline Software | Engineering | Paid | $8,500.00 |
| 13 | INV-1012 | Basecamp Events | Operations | Paid | $8,256.80 |
| 14 |
The visible columns and rows follow the active mission so each step stays focused.
Mission
Clean the vendor name helper column so the ledger is presentation-ready.
Question
What formula should you enter for the first helper-row value to remove extra spaces from the vendor name in row 2?
Hints
Your Answer