Перейти к содержимому
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 Simulated Excel Test (SHL-style, eSkill, Criteria)

A simulated Excel test puts a working copy of a spreadsheet in your browser and gives you one task at a time: format this range, write a formula here, rename that sheet. SHL's Excel 365 test has 30 tasks in 35 minutes and its Essentials version 20 tasks in 25 minutes; you get one attempt per task, the result is graded on the state of the sheet, and many keyboard shortcuts do not work. This is the family that staffing agencies and large employers use for administrative and finance-support roles.

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

Tasks
20–30. SHL Excel 365: up to 30 tasks; SHL Excel 365 Essentials: 20. Criteria's Interactive test adds three simulations to 12 multiple-choice questions; eSkill's count is set by the employer.
Time
25–35 minutes allowed. SHL's reseller sheets list 35 minutes allowed and 25 typical for the full test, 25 allowed and 15 typical for Essentials; Criteria Interactive takes about 7 minutes.
Per task
About 60–75 seconds at the allowed pace; the untimed Kenexa-style tests still recorded speed and scored it.
Navigation
Task list visible, forward with Next, one attempt per task. The simulation does not allow trial and error: what the sheet shows when you press Next is what is graded.
Shortcuts
Arrow keys and Enter work; Criteria states that most selection and command shortcuts (Ctrl + Shift + Arrow, Ctrl + C) are not supported, and its simulation shows only the Home-tab icons the tasks need. Expect to use the mouse.
Scoring
Tasks completed correctly, often weighted with speed, plus sub-scores by area: SHL reports Applying Formulas and Functions; Creating and Analyzing Data; Formatting Cells, Data and Content; Managing Workbooks and Worksheets; Presenting Data Visually; Printing and Views; Sharing, Maintaining and Securing Workbooks.
Where it is used
Staffing agencies, banks' operations teams, government and large employers for admin, bookkeeping, coordinator and support roles. SHL also hosts the former IBM Kenexa Prove It catalog; Prove It itself was retired in 2018.

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

The task list reads like the SHL sub-scores: formatting, formulas, data and worksheet management, charts, printing and workbook protection. Tasks are stated as actions on named cells and sheets, so you need to recognise the feature from its description rather than from a screenshot.

  • Formatting cells and ranges

    Font and fill, alignment, wrap text, merge and center, borders, number and date formats, Format Painter, column width. The largest share of tasks in reseller outlines.

    Практика: Merge and center the title; wrap header text
  • Formulas and functions

    SUM, AVERAGE, MIN, MAX, COUNT, IF, a VLOOKUP, references across sheets, absolute references. Typed once, correctly.

    Практика: Total across three regional sheets
  • Data: sort, filter, tables, validation

    Sort by two columns, apply a filter and read what remains, convert a range to a table, add a drop-down list.

    Практика: Filter one region and count visible rows with SUBTOTAL
  • Worksheets and workbooks

    Rename, move and colour sheet tabs, freeze panes, hide columns, insert and delete rows, set a print area or page orientation.

    Практика: Freeze the header row of a long export
  • Charts

    Insert a chart of a given type, change its title, switch rows and columns.

    Практика: Series or categories? Read a chart both ways and flip its table
  • Conditional formatting

    Add a built-in conditional-formatting rule, such as Top 10% or Greater Than.

    Практика: Highlight the top 10 % of sales
  • Protecting and sharing

    Protect a sheet, set a password, add a comment, save in another format. Rare but in SHL's outline.

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

Two things decide the score: knowing where each command lives in the ribbon without searching, and typing formulas right the first time. Both come from doing the tasks, not reading about them.

  1. 1

    Work the cell-mechanics exercises with the mouse only: freeze panes, merge and wrap, number and date formats, sort and filter. The grader reads the sheet state exactly as a simulation does.

    Практика: Freeze panes
  2. 2

    Type formulas in one go. Do the SUM, AVERAGE and COUNT set, then the absolute-reference set; check each one before pressing Enter, because in the test there is no second attempt.

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

    Practise one lookup and one IF until the argument order is automatic: a typo in a 30-second task is the task lost.

    Практика: VLOOKUP
  4. 4

    Learn the Home-tab layout of Excel for the web or desktop Excel by heart: alignment group, number group, Format as Table, Conditional Formatting, Insert menu. Simulations mirror it.

  5. 5

    Rehearse the clock with the free Level 1 test today and Level 2 when it opens: a visible task list, forward-only navigation and one attempt per task are the same rules.

Level 2 follows this family: 20 tasks in one workbook, a 25-minute clock, task list visible, forward only, one attempt per task.

  • Подготовка за 7 дней: план уровня 2 →
  • Практика для работы: Excel for Sales and Marketing →
Пройти бесплатный тест уровня 2

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

  • A typo with no second attempt

    Simulations grade the sheet when you move on. Candidates lose tasks to a missing bracket or a wrong column letter they would have fixed in real Excel. Read the formula bar before Next.

  • Reaching for a disabled shortcut

    Ctrl + Shift + Arrow, Ctrl + C and Ctrl + V often do nothing in the simulation. Candidates who rely on them freeze; select with the mouse or Shift + Arrow and use the ribbon buttons.

  • Typing the value instead of a formula

    Testlify's grader lists "Correct result, but missing formula" as a failure reason, and simulations check the cell content, not just what it shows. If the task says calculate, write a formula.

  • Changing the wrong cell

    Tasks name an exact cell or range. Formatting B2:B20 when the task says B2:B21, or merging A1:E1 instead of A1:F1, scores zero.

  • Hunting through the ribbon

    At 60–75 seconds per task, looking for Freeze Panes under Home instead of View costs the task. Know the tab for each command.

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

Is it real Excel?

No. SHL, eSkill and Criteria run a simulated Excel interface in the browser; Testlify and Vervoe use a live sheet. The simulation looks like Excel but accepts fewer shortcuts and shows only part of the ribbon. TestDome instead asks you to complete a file in your own Excel and upload it.

Can I take it on a Mac?

Yes. Criteria says Mac users are not at a disadvantage; the simulation runs in the browser and uses the mouse for most actions. Practise the ribbon layout rather than Windows-only shortcuts.

What if I make a mistake in a task?

You can usually fix it before you press Next; after that the task is closed. Prep sites describe SHL's simulation as not allowing trial and error, so check the cell before moving on.

How is it scored?

By tasks completed correctly, with sub-scores by area and, in SHL's case, pace. Employers see a report with the breakdown; there is no published pass mark. A typical employer bar on prep sites is around 70–80%.

Where can I rehearse this format for free?

Our free Level 2 test reproduces the rules: 20 tasks in two business workbooks, one 25-minute clock, the task list visible, forward only, one attempt per task, with an 80% pass line and five sub-scores.

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

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

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

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

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

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

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

Facts checked on November 15, 2026 against SHL's business-skills catalog and reseller specification sheets for Microsoft Excel 365 and Excel 365 Essentials, Criteria's Microsoft 365 test documentation, eSkill's Excel simulation page (February 2025), Testlify's test-case documentation and prep-site descriptions of the SHL and Kenexa formats (2025).

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