Touch-First Spreadsheet App: Target Users, Core Jobs and Small-Screen Editing

Quick 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.

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.

Meta logo
Meta
Oct 30, 2024
mediumProduct ManagerOtherProduct Design & Strategy
0
0

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.

Clarifying Questions Guidance

  • 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 Guidance

  • 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 Guidance

  • 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?