Перейти к содержимому
GridBelt
  • Тест по Excel
  • Упражнения
  • Программы
  • Цены
Войти
Начать бесплатный тест
  • Тест по Excel
  • Упражнения
  • Программы
  • Цены
ВойтиСоздать аккаунт
Начать бесплатный тест
GridBelt

Тренируйте навыки Excel прямо в браузере.

Тест по Excel

  • Уровень 1: Начальный
  • Уровень 2: Средний
  • Уровень 3: Продвинутый
  • Подготовка к тесту по Excel за 7 дней
  • Таблица лидеров
  • Тест по Excel на собеседовании
  • Тест по Excel от Indeed

Упражнения

  • Все упражнения
  • Программы
  • Для начинающих

Материалы

  • Формулы Excel
  • Горячие клавиши Excel

Компания

  • О проекте
  • Цены
  • Как мы проверяем

© GridBelt. Все права защищены.

  • Политика конфиденциальности
  • Условия использования
  • Политика возврата средств

Excel — товарный знак корпорации Microsoft. Indeed, TestGorilla, SHL и другие товарные знаки принадлежат их владельцам. GridBelt — независимый сайт для практики: он не связан с Microsoft, TestGorilla, SHL или Indeed, не одобрен и не спонсируется ими.

  1. Тест по Excel

What to Expect on a Timed Multiple-Choice Excel Test (TestGorilla-style, iMocha, Adaface, Mettl)

The most common Excel test is a short multiple-choice screening sent as a link before anyone talks to you: 10 to 30 questions, 10 to 30 minutes, one question on the screen at a time, and a percentage or percentile at the end. The questions are theory and small scenarios, not a live spreadsheet. Here is what the vendors publish about the format, what candidates report, and how to be ready in a few hours.

Параметры формата

Questions
10–30, drawn from a bank. TestGorilla uses 12–20 per attempt from banks of 100 or more; iMocha 10; Adaface about 14 scenario questions; Mettl and Testlify 25–30.
Time
10–30 minutes in total. TestGorilla's Excel tests run 10–12 minutes, iMocha 20, Testlify 25–30, Mettl 30. Criteria's adaptive version takes about 5 minutes.
Per question
Roughly 40 seconds to 2 minutes. Adaface allows 2–3 minutes per scenario question; TestGorilla fits 12–20 questions into 12 minutes.
Navigation
One question per screen, forward only, no pause. Some tests time each question; most run one clock for the whole test.
Scoring
Percent correct, shown to you; recruiters see a percentile against everyone who took the test (TestGorilla), a Beginner to Advanced rating (Criteria) or a pass recommendation with a threshold around 55% (Adaface). No vendor publishes a pass mark.
Where it is used
Administrative, customer-service, sales-operations and entry-level analyst roles; sent from the applicant tracking system before a first call.

О чём спрашивают?

Vendors describe the content as features, functions and formulas, creating and formatting spreadsheets, and managing data. The question types repeat across vendors: a small spreadsheet screenshot with "which formula produces this result", a conceptual question about a feature, and a few on shortcuts or menus.

  • Which formula gives this result

    SUM, AVERAGE, COUNT and COUNTA on a screenshot range; IF with a simple condition; COUNTIF and SUMIF, the two functions TestGorilla names on its test page along with VLOOKUP.

    Практика: Count orders, names and blanks (COUNT, COUNTA, COUNTBLANK)
  • Lookups

    What VLOOKUP returns for a given table, exact versus approximate match, why a lookup shows #N/A.

    Практика: Pull the unit price with VLOOKUP (exact match)
  • References

    What happens to a formula when it is copied down, where the $ goes, how to point at another sheet.

    Практика: Apply one tax rate to every line ($ reference)
  • Formatting and cell mechanics

    Number and date formats, wrap text, merge versus center across selection, freeze panes, what a red triangle in a cell means (a Mettl sample question).

    Практика: Apply currency and date formats
  • Sort, filter, tables

    Multi-level sort, what a filter hides, how a table's total row behaves.

    Практика: Sort by Region, then Sales descending
  • Charts, read not built

    Pick the right chart type, read a chart from a screenshot, switch rows and columns.

    Практика: Pick the right chart for each question
  • PivotTables, read not built

    Read a PivotTable from a screenshot: what its rows, columns and grand totals show.

    Практика: Read a PivotTable report and check one of its cells
  • Shortcuts and menus

    iMocha's basic test lists keyboard shortcuts as a topic; Mettl asks for the AutoSum shortcut (Alt + =) and how to freeze a pane.

Как подготовиться?

You cannot look anything up during the test, so the preparation is recall under a clock: name the function from the result, and know what the common functions do without opening Excel.

  1. 1

    Take the free Level 1 test once, cold. It uses the same rhythm (a clock on every task, no going back) and its five sub-scores show which of the six areas to work on.

  2. 2

    Do the basics exercises: SUM, AVERAGE, MIN, MAX, COUNT, COUNTA and COUNTBLANK on real data, until the difference between COUNT and COUNTA is automatic.

    Практика: SUM, AVERAGE and COUNT
  3. 3

    Do the two absolute-reference exercises. "What happens when this formula is copied" is on every screening.

    Практика: Absolute references
  4. 4

    Review the formatting mechanics that screenings ask as theory: number formats, wrap text, merge, freeze panes.

    Практика: Merge and wrap
  5. 5

    Read the cheat sheet entries for IF, COUNTIF, SUMIF and VLOOKUP and work one exercise on each.

    Практика: IF function
  6. 6

    Retake the test the day before. Aim to finish with time to spare: the clock, not the content, is what catches people.

Level 1 is modeled on this family and on the discontinued Indeed test: 15 tasks, 90 seconds each, one task per screen, no going back.

  • Подготовка за 7 дней: план уровня 1 →
  • Практика для работы: Excel for Administrative Assistants →
Пройти бесплатный тест уровня 1

Какие ошибки стоят баллов?

  • Running the per-question clock down

    Candidates who know the material still lose questions by re-reading a screenshot. Read the question first, then look at the sheet for exactly what it asks.

  • COUNT versus COUNTA, SUMIF versus SUMIFS

    COUNT counts numbers only; COUNTA counts anything. SUMIF takes range, criteria, sum range; SUMIFS starts with the sum range. Screenshot questions are built around these swaps.

  • Forgetting the $ in a fill-down scenario

    "This formula is copied from C2 to C10; what does C10 show?" tests whether you notice an unlocked reference to a rate cell.

  • Half-answering a select-all-that-apply

    Multi-select questions score only when the whole set is right. Check every option; a single missed one is a zero.

  • Studying only hands-on skills

    Screenings also ask about menus and concepts: where freeze panes lives, what a filter does to hidden rows, what #N/A means. Theory you never read is theory you cannot recall.

Вопросы, которые задают кандидаты

Will I work in a real spreadsheet?

Usually not. TestGorilla, iMocha, Mettl, Adaface's main test and Criteria's standard test are multiple choice. Some vendors add a hands-on task (Adaface's Workbook test, Criteria's Interactive version with three simulations); the recruiter's invitation names the test.

Can I go back to a previous question?

Usually not. TestGorilla shows one question per screen with no return, and the legacy Indeed test timed each question separately. Treat every question as final.

What score do I need?

Vendors do not publish pass marks. TestGorilla reports a percentile against all test takers, Criteria a rating from Beginner to Advanced, Adaface suggests a threshold around 55% that employers can change. Prep sites commonly recommend aiming for 70% or better.

Can I retake it?

Only if the employer sends a new invitation. Each attempt draws different questions from the bank, so a retake is a new test, not the same one.

Can I take it on my phone?

The multiple-choice tests work on a phone, but screenshot questions are hard to read on a small screen and some tests disable switching tabs. Use a laptop with a stable connection.

Другие форматы тестов

ФорматДлительность и объёмКак это выглядит
  • 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.

    Чего ждать от этого теста
  • 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.

    Чего ждать от этого теста
  • Employer workbook test

    Written by the hiring team; sometimes run live over screen share

    20–60 minutes One workbook

    Raw data on two or three sheets, a list of questions, your own Excel. Join, aggregate, clean, summarize, explain.

    Чего ждать от этого теста

Попробуйте в настоящей таблице

Бесплатно, без регистрации и без установки.

Пройти бесплатный тест уровня 1Перейти к упражнениям

Facts checked on November 15, 2026 against the test-library pages of TestGorilla, iMocha, Adaface, Mettl, Testlify and Criteria and against TestGorilla's scoring documentation. Question counts for TestGorilla's Excel tests are the range the company publishes for its multiple-choice tests; the exact count per test is not published.

Excel — товарный знак группы компаний Microsoft. Indeed, TestGorilla, SHL, iMocha, Adaface, Criteria и другие товарные знаки принадлежат их владельцам. GridBelt — независимый проект: он не связан ни с одной из этих компаний, не одобрен и не спонсируется ими.