Touch-First Spreadsheet App: Target Users, Core Jobs and Small-Screen Editing
Company: Meta
Role: Product Manager
Category: Product Design & Strategy
Difficulty: medium
Interview Round: Other
You are a product manager asked to design a spreadsheet product for mobile phones. Explain who it is for, which spreadsheet tasks it must handle well on a small touch screen, what the core experience looks like, and how you would know it is succeeding.
```hint Jobs, not features
A desktop spreadsheet assumes a big screen, a keyboard and a precise pointer. Work out what people actually need to do with a spreadsheet when a phone is all they have.
```
### Clarifying Questions
- Is this a new standalone app, or a mobile companion that must open and edit files from existing desktop spreadsheet tools without breaking them?
- Who is the target: people managing personal lists and budgets, small businesses tracking stock and orders, or office workers reviewing sheets sent to them?
- Phones only, or tablets too?
- Does it need to work offline and let several people edit the same sheet?
### What a Strong Answer Covers
- Mobile spreadsheet user segments and a reasoned target, with a clear view of which jobs belong on a phone and which stay on the desktop.
- Concrete answers to small-screen problems: reading wide tables, selecting cells and ranges, entering formulas and typing numbers.
- A prioritized MVP, with a reason for what is left out.
- File compatibility, offline editing and collaboration.
- Success metrics with guardrails.
### Follow-up Questions
- A user opens a 40-column financial model on their phone. What do they see first, and how do they find the number they need?
- How would you make formula entry workable without a physical keyboard?
- Two people edit the same cell while one of them is offline. What happens when they reconnect?
Overview: A product design question asking how to build a spreadsheet app for mobile phones. It tests choosing a target user, separating the spreadsheet jobs that suit a small touch screen from those that belong on a desktop, solving data entry and navigation on small screens, and defining success metrics.