Pular para o conteúdo
GridBelt
  • Teste de Excel
  • Prática
  • Programas
  • Preços
Entrar
Começar o teste gratuito
  • Teste de Excel
  • Prática
  • Programas
  • Preços
EntrarCriar conta
Começar o teste gratuito
GridBelt

Pratique Excel no seu navegador.

Teste de Excel

  • Nível 1: Iniciante
  • Nível 2: Intermediário
  • Nível 3: Avançado
  • Teste de Excel em 7 dias
  • Ranking
  • Teste de Excel para entrevista
  • Avaliação de Excel da Indeed

Prática

  • Todos os exercícios
  • Programas
  • Para iniciantes

Guias

  • Fórmulas do Excel
  • Atalhos do Excel

Empresa

  • Sobre nós
  • Preços
  • Como corrigimos

© GridBelt. Todos os direitos reservados.

  • Política de Privacidade
  • Termos de Uso
  • Política de Reembolso

Excel é uma marca comercial da Microsoft Corporation. Indeed, TestGorilla, SHL e outras marcas pertencem aos seus respectivos proprietários. O GridBelt é um site de prática independente e não tem afiliação com Microsoft, TestGorilla, SHL ou Indeed, nem é endossado ou patrocinado por eles.

  1. Teste de Excel

What to Expect on an Employer's Excel Workbook Test (Analyst, FP&A, Admin)

For analyst, FP&A, pricing, operations and office roles, the Excel test is usually not a vendor product but a workbook the team built: a few sheets of raw data, a list of questions, and 20 to 60 minutes to answer them in your own Excel, sometimes while sharing your screen. Finance roles stretch the same idea to one-to-three-hour modeling tests and take-home cases. There is no published rubric; graders look for accuracy first, then completeness, then structure, then formatting.

Dados do formato

Time
Most analyst screens run 20–60 minutes (Interview Query, May 2026). Live screen-share tests of about 30 minutes and emailed one-hour assignments are common; investment-banking and private-equity modeling tests run 1–3 hours; take-home cases are due in 24–72 hours and take 4–8 hours of work.
Material
One workbook or several CSV files: transactions, a lookup table (products, customers, regions), sometimes a half-built summary sheet. Data is deliberately imperfect.
Tasks
A handful of written questions. Recurring ones: join the tables, total by category and period, clean the dates, remove duplicates, build a summary or PivotTable, chart one series, and write two or three sentences on what the numbers mean.
Tools
Your Excel (or Google Sheets), occasionally the employer's laptop. Finance teams expect Windows Excel and keyboard speed; some forbid macros.
Grading
No published rubric. The order graders describe: accuracy (does the balance sheet balance, do the totals tie), completeness, model or sheet structure, formatting. Training vendors report median scores below 50% on timed modeling tests.
Follow-up
Expect to explain the result: a written answer box, a verbal walk-through on the call, or a presentation of a take-home. The right number without the reasoning scores poorly.

O que eles perguntam?

Across analyst guides, Big Four and bank interview reports, the same seven tasks appear. Candidate reports from EY, J.P. Morgan and Deloitte name SUMIF, VLOOKUP and COUNTIF and a one-hour live finance case; data-analyst guides add pivot summaries, date standardization and QA checks.

  • Lookups and joins

    Bring the product category or customer segment onto the transactions with VLOOKUP, XLOOKUP or INDEX and MATCH, and check the key for duplicates first.

    Praticar: Replace VLOOKUP with XLOOKUP
  • Criteria sums and counts

    Revenue by region and month, orders above a threshold, conversion rates per channel: SUMIFS and COUNTIFS, sometimes AVERAGEIFS.

    Praticar: Sales by region and product with SUMIFS
  • Flags with IF

    Late deliveries, margins below target, eligibility rules: IF with AND or OR, IFERROR around divisions.

    Praticar: Bonus eligibility with IF and AND
  • PivotTable summary

    Sales by rep by quarter, grouped rates, a top-10 list. Build it, or rebuild it with formulas when the test forbids PivotTables.

    Praticar: Pivot without a pivot: revenue by category and month with SUMIFS
  • Date cleanup

    Dates stored as text in two formats, month and year columns, working days between two dates.

    Praticar: Turn text dates into real dates and group by month
  • Duplicates, blanks and categories

    Remove duplicate rows, treat "N/A" and blanks consistently, unify "West" and "west ".

    Praticar: List unique customers (UNIQUE) — remove duplicates
  • Percentages and a chart

    Share of total, growth versus last year, a column or line chart of one series with a sensible title.

    Praticar: Year-over-year % change

Como me preparar?

Speed on messy data is the whole skill. Practise on datasets with dirt in them, keep a QA habit (totals, duplicate keys, impossible values), and rehearse saying what a number means in one sentence.

  1. 1

    Do the lookups track: exact and approximate VLOOKUP, XLOOKUP, INDEX and MATCH, and the #N/A handling exercise. Then practise counting duplicates on the key before any join.

    Praticar: VLOOKUP
  2. 2

    Do the SUMIFS and COUNTIFS exercises with two and three criteria.

    Praticar: SUMIF and SUMIFS
  3. 3

    Rebuild a PivotTable with formulas, the way out when the test says formulas only: a category-by-month grid with one SUMIFS, then a summary by region with GROUPBY in Excel 365.

    Praticar: Pivot tables
  4. 4

    Work the text and date exercises: text to real dates, EOMONTH due dates, NETWORKDAYS, split and trim names.

    Praticar: Date functions
  5. 5

    Do the UNIQUE and FILTER exercises and the conditional-formatting rules for overdue items.

    Praticar: Remove duplicates
  6. 6

    Time yourself. Give every practice session a clock of 20 minutes for five tasks, and write one line of interpretation under each answer, as if the grader will read it.

  7. 7

    Learn the keyboard moves that finance tests assume: Ctrl + Shift + Arrow to select, F4 to lock a reference, F2 to edit, Alt + = for AutoSum, Ctrl + 1 for the format dialog.

Our Level 2 test puts 20 tasks into two business workbooks of two to three sheets with one 25-minute clock, the closest free rehearsal for this family.

  • Prepare-se em 7 dias: o plano do nível 2 →
  • Pratique para o cargo: Excel for Data Analysts →
  • Pratique para o cargo: Excel for Accounting and Bookkeeping →
Fazer o teste gratuito de nível 2

Quais erros custam pontos?

  • Row multiplication from a join

    A lookup key that appears twice in the reference table doubles every matching row. Analyst guides call it the hidden risk; count the key with COUNTIF before you join, and compare totals before and after.

  • The denominator is wrong

    "Most spreadsheet mistakes are really filtering mistakes": a rate computed over all rows when the question asked about one region, or over filtered rows when it asked about all.

  • Running out of time

    Candidates report tests that took two to three hours when the email said 30 to 60 minutes. Answer every question roughly first, then refine; a blank question scores nothing.

  • Hard-coded values

    A total typed in, a tax rate inside a formula, a copied number instead of a link: graders check formulas, and a number nobody can trace fails the accuracy test.

  • Over-building and over-formatting

    A full three-statement model when a growth table was asked for, colours and borders before the numbers are right. Structure and formatting rank after accuracy and completeness.

  • Not reading the prompt

    Modeling-test guides list "did not read the prompt" next to hard-coding as the most common failure: wrong period, wrong unit, wrong definition of margin.

Perguntas que os candidatos fazem

How long is an Excel test for an analyst interview?

Most are 20–60 minutes. Live screen-share versions run about 30 minutes; emailed assignments are often an hour; investment-banking and private-equity modeling tests run one to three hours; take-home cases give you 24–72 hours for four to eight hours of work.

How is it graded?

Against the team's own answer key, in roughly this order: accuracy, completeness, structure, formatting. Interview guides for banks say balance sheets that do not balance and hard-coded numbers are the most damaging errors, and that reasoning is weighed as heavily as the final numbers.

Do I need PivotTables?

Often, yes, for a summary by category and period. Know how to build one and how to produce the same table with SUMIFS and COUNTIFS when the test says formulas only.

Can I use Google Sheets?

Only if the employer offers it. Finance teams expect Excel on Windows and keyboard speed; data teams are often flexible. Ask before the test, not during it.

Will I have to explain my answers?

Usually. Expect a written-answer cell or a conversation about why you chose a method and what the number means for the business. Practise saying it in one or two sentences.

Os outros formatos de teste

FormatoDuração e tamanhoComo é
  • Timed multiple-choice screening

    TestGorilla-style, iMocha, Adaface, Mettl, Testlify

    10–30 minutes 10–30 questions

    One question per screen with a clock, usually no going back. The first filter after the CV.

    O que esperar deste teste
  • Simulated spreadsheet test

    SHL-type, eSkill, Criteria Interactive, Testlify, Vervoe

    25–35 minutes 20–30 tasks

    A mock Excel window with a task under it. One attempt per task, graded on the end result, some shortcuts switched off.

    O que esperar deste teste
  • MOS-style project exam

    Microsoft Office Specialist exams MO-210 and MO-211 (Certiport)

    50 minutes 23–37 tasks

    Several projects in live Excel, each a workbook with 4–7 tasks. Scored 1–1000, 700 to pass.

    O que esperar deste teste

Experimente em uma planilha de verdade

Grátis, sem conta e sem instalar nada.

Fazer o teste gratuito de nível 2Ver exercícios de prática

Facts checked on November 15, 2026 against Interview Query's data-analyst Excel assessment guide (May 1, 2026), investment-banking modeling-test guides (updated November 3, 2026), Mergers & Inquisitions on timed LBO tests, the AFP's FP&A case-interview article (updated May 7, 2024), and candidate interview reports for EY, Deloitte and J.P. Morgan. Employers do not publish rubrics; the grading order is how those guides describe it.

Excel é uma marca comercial do grupo de empresas Microsoft. Indeed, TestGorilla, SHL, iMocha, Adaface, Criteria e outras marcas pertencem aos seus respectivos proprietários. O GridBelt é independente e não tem afiliação com nenhum deles, nem é endossado ou patrocinado por eles.