Interview blog

Capital One Digital Problem-Solving Exercise for Analysts

Written March 14, 2026Updated November 11, 20269 min read
How Can I Master The Capital One Business Analyst - Digital Problem-Solving Exercise

What Capital One's business analyst spreadsheet exercise looks like, where it sits in the process, and three worked problems to practise before you start.

The Capital One business analyst digital problem-solving exercise, as candidates describe it, is a spreadsheet-based quantitative assessment that many business analyst applicants take after the Virtual Job Tryout (VJT). Candidate reports describe roughly 7 to 13 business math questions built on a data file you work through in Excel or Google Sheets, sometimes with a short written explanation for each answer. The math is percentages, weighted averages, break-even and growth, not coding. What separates candidates is setting each problem up correctly, stating assumptions, and showing work a hiring manager can follow. Pass it and the next steps are a mini case and Power Day.

For how the whole business analyst interview works, including the requirements exercise and stakeholder questions, see our guide to the business analyst interview.

What Capital One says, and what it doesn't

Capital One's careers FAQ describes the VJT, not this exercise. It says the VJT arrives by email, takes 20 to 45 minutes on average, and combines modules depending on the role: Manage Relationships, Work Your Business Case, Tell Us Your Story and Describe Your Approach. None of Capital One's public pages that we could open uses the name "digital problem-solving exercise" or describes the spreadsheet test.

Capital One's own article on the business analyst interview covers what comes after. Interviews typically start with a mini case, then a virtual Power Day with two to three more case interviews and a product strategy conversation. It warns candidates to expect a lot of math, and says most business analysts interview for the job family as a whole and are matched to a team later.

Analysts applying beyond Capital One can see how its mini case and Power Day line up with other banks' interviews in our breakdown of big-bank hiring stages.

Everything about the exercise itself comes from candidate reports and prep sites that compile them, so read the details as a common shape, not a promise.

How this exercise fits into the rest of Capital One's hiring, from the recruiter screen to Power Day, is covered in our overview of Capital One interview questions and how the process works.

Where it sits in the process

  • Stage — What sources describe
  • Virtual Job Tryout — Official: 20 to 45 minutes, scenario and profile modules. The Work Your Business Case module has you review information about a fictional business and propose solutions.
  • Quantitative / spreadsheet exercise — Reported for business analyst candidates. Sources disagree on whether it is a VJT module or a separate step before the mini case; your invitation will show which. We could not confirm the name "digital problem-solving exercise" on any Capital One page.
  • Mini case — Official: the first interview, a short case to test problem solving.
  • Power Day — Official: two to three cases plus a product strategy conversation. Recent reports describe two business cases and one product interview in a block of about four hours.

Not everyone gets every step. A compilation of 38 business analyst intern reports notes that some candidates went from an assessment straight to Power Day, while others did an extra case first.

What the exercise looks like in reports

The reports agree on the content and disagree on the format.

  • Number of questions. One guide says 7 to 11 quantitative problems. Intern reports from 2024 to 2026 mention 12 data questions, 13 data questions, and in one case seven questions that each needed a written explanation.
  • Time. Reports differ on timing. Two September 2025 intern reports describe a two-hour spreadsheet assessment. Check your invitation; it will state the limit.
  • Tools. A compilation of intern reports says several recent candidates completed Excel or Google Sheets exercises. Correct formulas alone were not enough; the written reasoning counted too.
  • Question types. Weighted averages, break-even and payback periods, percent growth, and word problems that turn a business scenario into an equation.

Two things it is not. It is not a coding test: the reports describe business math in a spreadsheet. If your invitation says CodeSignal, our Capital One CodeSignal guide covers that test. And it is not a personality quiz. That part is the VJT.

Three worked problems

The first is a question reported by candidates and published by a prep site. The second is a typical word problem in the same style. The third is a practice drill with invented numbers, built to match the spreadsheet format.

1. The question with two readings

A venue sold 900 tickets to four weeks of shows. A survey says 60% of fans came once, 30% twice, 6% three times and 4% four times. How many unique people attended?

Read literally, the percentages describe fans. The average fan bought 0.60×1 + 0.30×2 + 0.06×3 + 0.04×4 = 1.54 tickets, so unique fans = 900 ÷ 1.54 ≈ 584.4. That is not a whole number, which is a signal worth noticing.

If the percentages describe tickets instead, the numbers come out clean: 540 tickets from one-time fans (540 people), 270 from two-time fans (135 people), 54 from three-time fans (18 people) and 36 from four-time fans (9 people), for 702 unique fans.

What to do in the exercise: compute the reading the wording supports, note that the result is not a whole number, and write one sentence saying which reading you used and why. A reviewer can disagree with your assumption and still see that you checked it. Leaving it unstated looks like an error.

2. The equation hidden in a story

A volleyball team won 75% of its first 112 games and 25% of the rest. It finished the season at 60%. How many games did it play?

Wins in the first stretch: 0.75 × 112 = 84. Call the remaining games x. Then (84 + 0.25x) ÷ (112 + x) = 0.60, so 84 + 0.25x = 67.2 + 0.6x, which gives x = 48. The team played 160 games. Check: 84 + 12 = 96 wins, and 96 ÷ 160 = 60%.

The check takes ten seconds and catches most setup mistakes. Make it a habit on every answer.

3. A spreadsheet drill: the obvious story is wrong

Practice data, invented for this drill:

  • Channel — Q1 accounts — Q1 revenue — Q2 accounts — Q2 revenue
  • Online — 40,000 — $2,000,000 — 44,000 — $2,000,000
  • Branch — 10,000 — $1,000,000 — 8,000 — $900,000

Revenue fell last quarter. Which channel is responsible?

Set it up in the sheet with one formula per idea: total revenue with =SUM(), change with =(Q2-Q1)/Q1, revenue per account with =revenue/accounts.

  • Total revenue fell from $3.0M to $2.9M, down 3.3%, while accounts grew 4%.
  • Online revenue per account fell from $50.00 to $45.45, which looks like the culprit. But online revenue was flat: more accounts at a lower rate.
  • Branch lost 20% of its accounts. Its revenue per account rose from $100 to $112.50, but branch revenue still fell by $100,000, which is the entire decline.

A strong written answer is two sentences: "The whole $100,000 decline came from branch, where accounts fell 20%. Online revenue per account fell, but account growth offset it, so online revenue was flat." The weak answer stops at the first ratio that moved.

Spreadsheet skills to have ready

You do not need advanced modelling. You do need to be quick and clean with:

  • SUM, AVERAGE, SUMIF/SUMIFS and COUNTIF for totals by group
  • Percent change and percent of total, with absolute references ($B$2) so formulas copy correctly
  • XLOOKUP or VLOOKUP to join two tables, and a pivot table for a quick breakdown by category
  • Sorting and filtering to find the top or bottom item fast
  • Labelling: a header on every helper column and one sentence of explanation next to each answer

If your sheet will be reviewed by a person, make it readable by someone who never saw the question. Reports say correct formulas alone were not enough and written reasoning counted, so make the sheet easy to follow.

A five-day plan

  • Day 1: Read your invitation for the format, the deadline and whether it is timed. Do the three problems above without looking at the answers.
  • Day 2: Twenty weighted-average and percent-change word problems. Write the equation before touching numbers.
  • Day 3: Break-even and payback: fixed costs, variable costs, contribution per unit, and units needed to recover an investment. Break-even is also the most frequently reported case topic in the intern compilation, so this day pays off twice.
  • Day 4: One full practice sheet under the stated time, with a written sentence for every answer. Then check every answer against the original question.
  • Day 5: Rest your arithmetic and start preparing for the mini case. Capital One's own advice for case interviews is to share your reasoning, organise your notes, and end with a recommendation backed by data. Our Capital One Power Day guide covers the final round.

After the exercise: practise the cases out loud

The spreadsheet exercise lets you work in silence. The mini case and Power Day do not: you have to talk through the same math while someone listens. If you want spoken practice, Verve AI's mock interview lets you pick a Consulting or Finance question bank, answer an AI interviewer's questions one at a time, and get a performance report with feedback and scores at the end. Use it to rehearse explaining a break-even setup clearly, which is the skill both the exercise and the cases reward.

Sources

  • Virtual Job Tryout modules (including Work Your Business Case), delivery by email, 20 to 45 minutes; interviews held on Zoom: https://www.capitalonecareers.com/faq
  • Business analyst process (mini case, Power Day with two to three cases and a product strategy conversation, math emphasis, job-family hiring): https://www.capitalonecareers.com/en/cracking-the-business-analyst-interview-students-101-cdev
  • Capital One case interview advice (share reasoning, recommendation backed by data, no single right answer): https://www.capitalonecareers.com/4-tips-to-ace-your-capital-one-case-interview-101-students
  • Business analyst process overview and reported quantitative question types: https://igotanoffer.com/en/advice/capital-one-business-analyst-interview
  • 38 business analyst intern reports (spreadsheet assessments with 12, 13 or 7 questions, two-hour versions, written explanations, Power Day format, break-even as most reported topic, some candidates skipping steps): https://www.fastprep.io/experience/capital-one-business-analyst-intern-power-day-38-interview-experiences-3fc2do8iiy
  • Business analyst quantitative assessment (7 to 11 problems) solved in a spreadsheet; venue problem as a weighted-average setup: https://www.hackingthecaseinterview.com/pages/capital-one-case-interviews
  • Verve AI Mock Interview (question banks, one question at a time, performance report with feedback and scoring): https://docs.vervecopilot.com/features/mock-interview
R

Ryan

CEO of Verve AI

Related reads

Explore related blog posts

Business Analyst Interview: Show How You Find the Real Need
October 28, 2026Interview blog

Business Analyst Interview: Show How You Find the Real Need

A business analyst interview tests whether you can find the need behind a request. See each stage, a worked requirements exercise and a two-week plan.

Read story
Online Assessment Test: The Main Types and How to Prepare for Each
December 13, 2024Interview blog

Online Assessment Test: The Main Types and How to Prepare for Each

Online assessment test types explained: CCAT, TestGorilla, SHL and game-based tests, with format, timing, rules and how to prepare.

Read story
Bank Interview Process: How Five Big US Banks Compare
November 11, 2026Interview blog

Bank Interview Process: How Five Big US Banks Compare

How the bank interview process works at JPMorgan, Bank of America, Wells Fargo, Capital One and Goldman Sachs, where they differ, and how to prepare once.

Read story
What Should You Know Before Interviewing For Business Analyst Remote Jobs
February 11, 2026Interview blog

What Should You Know Before Interviewing For Business Analyst Remote Jobs

Prepare for remote business analyst interviews with key skills, common questions, tools, and communication tips.

Read story
Top 30 Most Common Interview Questions For A Business Analyst You Should Prepare For
June 24, 2025Interview prep guide

Top 30 Most Common Interview Questions For A Business Analyst You Should Prepare For

Master interview questions for a business analyst with proven strategies, sample answers, and expert tips. Boost your chances of landing your next interview.

Read guide
Top 30 Most Common Business Analyst Interview Questions And Answers You Should Prepare For
October 10, 2025Interview prep guide

Top 30 Most Common Business Analyst Interview Questions And Answers You Should Prepare For

Master business analyst interview questions and answers with proven strategies, sample answers, and expert tips. Boost your chances of landing your next interview.

Read guide
Why Should You Master Add Column To Table SQL Before Your Next Interview
March 20, 2026Interview blog

Why Should You Master Add Column To Table SQL Before Your Next Interview

Master adding columns to SQL tables before your next interview with clear commands, examples, and common pitfalls.

Read story
What Should You Know About How To Add Promotion On LinkedIn To Accelerate Your Career
February 6, 2026Interview blog

What Should You Know About How To Add Promotion On LinkedIn To Accelerate Your Career

Discover how to add a promotion on LinkedIn to showcase growth, boost visibility, and accelerate your career.

Read story
How Do You Address A Cover Letter Without A Name When Every Impression Counts
February 25, 2026Interview blog

How Do You Address A Cover Letter Without A Name When Every Impression Counts

Learn professional greetings and templates for addressing a cover letter without a name to make every impression count.

Read story

Walk into every interview prepared and confident

Get Started For Free

Available on Mac, Windows, browser and mobile