Bài kiểm tra Excel khi tuyển dụng
See how candidates read worksheet examples and apply intermediate Excel knowledge under a short time limit.
- 10 phút
- 15 câu hỏi
- Trung cấp
- Trắc nghiệm nhiều lựa chọn
- Câu hỏi bằng Tiếng Anh
- Chỉ dành cho máy tính để bàn
Câu trả lời ngắn gọn
This Excel skills test checks intermediate Microsoft Excel work: formulas with lookup, conditional, text and date functions, working with data through sorting, filtering, tables and pivot tables, and formatting. Candidates answer 15 single-choice questions about worksheet pictures in 10 minutes on a computer. It suits administration, operations, sales support, finance support, reporting and junior analyst roles.
Nội dung đánh giá
Working knowledge of Excel formulas, data tools and formatting, read from worksheet pictures.
Formulas
Covers reading lookup, conditional, text and date functions and determining what a formula returns.
Data
Covers choosing how to sort, filter, use tables and summarize information with pivot tables.
Formatting
Covers conditional formatting, number formats and charts used to make worksheet information clear.
Các dạng câu hỏi
Trắc nghiệm nhiều lựa chọn
Ứng viên: Đọc một tình huống, bảng hoặc nhận định ngắn rồi chọn đáp án đúng hoặc tất cả các đáp án đúng.
Bạn sẽ thấy: Ứng viên có hiểu đủ sâu để áp dụng kiến thức hay chỉ nhận biết được kiến thức đó.
15 câu hỏi trong 10 phút, lần lượt từng câu một.
Các vị trí phù hợp với bài đánh giá này
Roles that work in spreadsheets: administration, operations, sales support, finance support, reporting and junior analyst roles.
What the Excel skills test shows that a resume does not
Formulas they can read, not just list
A resume says "advanced Excel". The test shows whether a candidate can look at a worksheet and predict what a lookup, conditional, text or date formula returns.
How they work with data
Questions on sorting, filtering, tables and pivot tables show whether someone picks the approach that gives a correct, repeatable answer from a real table.
Formatting that helps people read a sheet
Conditional formatting, number formats and charts decide whether a report is read correctly. The Formatting result shows how well a candidate handles them.
Evidence you can compare
Every candidate answers the same kind of questions in the same 10 minutes, so you compare like with like instead of comparing how confidently two resumes describe Excel.
Thông tin bạn nhận được về từng ứng viên
- Luôn ở trên thẻ làm bài kiểm tra
- Không dán câu trả lời
- Trả lời với tốc độ ổn định
Điểm số, hồ sơ và tín hiệu về tính liêm chính là những bằng chứng để bạn xem xét cùng với buổi phỏng vấn, không bao giờ là căn cứ cho quyết định tự động.
Dùng thử bài kiểm tra này miễn phí
How the Excel skills test resists AI help
Each candidate gets a different set of questions drawn from large pools, and the order of questions and answer options is shuffled. Questions arrive one at a time from the server, candidates cannot go back to an earlier question, and the answer keys never reach the browser. Timing runs on the server, so a reload returns the same question with the time left.
Question text cannot be copied, and a blocked copy is recorded. Signals such as time away from the tab, pastes and very fast answers are summarized in an Integrity Score with a timeline for the employer to review. The score describes what was observed; it never decides anything about the candidate.
Cách chúng tôi ngăn chặn gian lận bằng AI · Tín hiệu về tính liêm chính
Use the score with a work sample and a structured interview
Read the result as one piece of evidence, never on its own. Look at the three sub-skill results as well as the total: a reporting role leans on Formulas and Data, while a role that builds dashboards for managers also needs Formatting.
The best work sample for an intermediate Excel role is a small, messy dataset with a clear question. Give 100 rows of sales with a few missing values and duplicates, and ask for revenue by week and a short note on how the gaps were handled. It mirrors the work and shows whether the candidate checks their data or just produces a number. Then ask every candidate the same questions in a structured interview.
Interview questions to ask after the Excel skills test
What checks do you make before you share a surprising result from a spreadsheet?
Listen for reconciling totals against the source, looking for duplicates and missing values, and re-reading the formulas behind the number.
How do you make sure a lookup formula returns the right row?
Strong answers mention asking for an exact match, checking the lookup column for duplicates and handling the case where no match is found.
You need totals by region from a large table that is updated every week. How would you set that up?
Listen for a table or pivot table that can be refreshed, rather than totals typed in by hand, and for a check that new rows are included.
Tell me about a report you formatted so that someone else could read it quickly. What choices did you make?
Listen for number formats that match the data, conditional formatting used sparingly to point at what matters, and a chart chosen for the question being asked.
Tìm hiểu cách chấm điểm và các tiêu chuẩn đối chiếu
Who should use this Excel skills test?
Use this Excel skills test for roles that turn raw data into answers in spreadsheets: administrators keeping trackers, operations coordinators reconciling orders, sales support staff preparing pipeline reports, finance support staff summarizing spend, and junior analysts building weekly reports. A junior data analyst or an office administrator are typical examples.
It is pitched at intermediate, everyday use. The questions cover formulas (lookup, conditional, text and date functions), working with data (sorting, filtering, tables and pivot tables) and formatting (conditional formatting, number formats and charts). Each question shows the worksheet it asks about, so nothing depends on remembering where a button sits on a particular screen, and functions work as they do in current versions of Excel with US settings.
If the role needs deeper modeling or analysis, the test library also holds more advanced Excel tests. If the job rarely touches a spreadsheet, leave the Excel test out and test the skill the job does depend on.
It is an intermediate Excel test: candidates who know only basic entry and formatting will find the lookup, conditional and pivot table questions demanding, which is the point.
Common lookup and summary errors to probe in the interview
Intermediate spreadsheets fail in quieter ways than basic ones. The formulas run, the numbers look plausible, and the error only surfaces when someone checks. These are the traps worth asking about in the work sample and the interview.
- Approximate matches by accident. A lookup left on approximate match can return a wrong row from unsorted data instead of an error.
- Duplicates in the lookup column. A lookup returns the first match only, so a duplicated product code quietly hides the second record.
- Mismatched ranges in conditional totals. The ranges being tested and the range being added must cover the same rows, or the total is wrong without any warning.
- Stale pivot tables. A pivot table built last week does not include this week's rows until it is refreshed.
- Numbers that only look right. A number format that hides decimals, or dates read the wrong way round, can make a correct sheet read wrongly.
Candidates who know these traps check their own work before sharing it, which is the habit an intermediate spreadsheet role needs most.
An Excel skills test or a course on the resume?
Many candidates list an Excel course or exam on their resume. That shows effort and some baseline knowledge at one point in time. A short Excel assessment test shows what someone can do today, with everyday worksheet questions, under the same conditions as every other candidate.
For screening, the test is fairer and more current. Many capable people learned Excel on the job and never sat an exam, and spreadsheet skills fade without use. Asking everyone to take the same test gives you comparable evidence whatever route each person took.
Treat a course on the resume as a pleasant extra rather than a requirement, unless the role genuinely needs one. Then use the test result, a short work sample and a structured interview together, so no single document or number carries the decision.
Give candidates a short chance to try the worksheet format
Candidates can use the 4-question practice set, which takes 4 minutes, before the assessment. It lets them get used to reading worksheet pictures and choosing an answer before the timed questions start, and practice answers do not count toward the score. Mention the practice set when you invite candidates, alongside the 10-minute assessment and the requirement to use a computer.
Tính công bằng và các điều chỉnh phù hợp
Worksheets use everyday business data with no money symbols, dates written so they cannot be misread, and functions as they work in current versions of Excel with US settings. Each question shows the worksheet it asks about, so nothing depends on remembering a particular screen, and the test asks for a computer so the worksheets are large enough to read.
Bạn có thể cho bất kỳ ứng viên nào thêm thời gian như một biện pháp hỗ trợ. Kết quả là bằng chứng để con người xem xét, không bao giờ là quyết định tự động.
Provisional: reliability is reported once 200 candidates have completed it.
Chi tiết bài kiểm tra
Worksheet questions on everyday Microsoft Excel work at an intermediate level: formulas (lookup, conditional, text and date functions), working with data (sorting, filtering, tables and pivot tables), and formatting (conditional formatting, number formats and charts). Each question shows a worksheet and asks what a formula returns, what an action does, or which approach is right.
- Câu hỏi bằng tiếng Anh.
- Không cần dùng tài liệu hỗ trợ.
- Mỗi câu hỏi chỉ được trả lời một lần, theo thứ tự và không thể quay lại.
- 4 câu hỏi luyện tập, 4 phút, trước bài kiểm tra tính giờ.
- Được thực hiện trên máy tính để bàn hoặc máy tính xách tay.
Microsoft Excel là nhãn hiệu thuộc sở hữu của chủ sở hữu tương ứng. HireValid không liên kết với hoặc được chứng thực bởi nhãn hiệu này.
Câu hỏi thường gặp
What is on the Microsoft Excel Intermediate test?+
Fifteen single-choice questions in 10 minutes, in three areas: formulas (lookup, conditional, text and date functions), data (sorting, filtering, tables and pivot tables) and formatting (conditional formatting, number formats and charts). Each question shows a worksheet and asks what a formula returns, what an action does, or which approach is right.
Do candidates need Excel installed to take the Excel skills test?+
No. Each question shows a picture of the worksheet it asks about, and candidates choose an answer on screen, so nothing needs to be installed. If you add a hands-on work sample later, candidates will need spreadsheet software for that step.
Can candidates take the Excel Intermediate test on a phone?+
No. The test asks for a computer, so the worksheets are large enough to read. Say so in the invitation, and offer another arrangement to any candidate who does not have access to a desktop or laptop, so nobody is disadvantaged by their device.
Which version of Excel does the Excel skills test assume?+
Functions work as they do in current versions of Excel with US settings. Worksheets use everyday business data with no money symbols and dates written so they cannot be misread, and each question shows the worksheet it asks about, so nothing depends on remembering a particular screen.
Is the Excel Intermediate test enough for a junior data analyst role?+
It covers the spreadsheet side of the job: formulas, data tools and formatting. Many analyst roles also pull data from a database, so consider adding a SQL test from the library, and use a short work sample with a real dataset to see how the candidate checks their numbers.
Can candidates go back to an earlier question on the Excel skills test?+
No. Questions are served one at a time and candidates cannot return to an earlier one, so each answer is final when it is given. Tell candidates this in the invitation so the format does not surprise anyone.
What practice is available before the Microsoft Excel Intermediate test?+
Candidates can try 4 practice questions in 4 minutes before starting the 15-question assessment. The practice set introduces the format: a worksheet picture, one question at a time, and a single answer to choose. Practice answers do not count toward the score, so candidates can settle in before the timed questions start.
What does the Microsoft Excel Intermediate test show about pivot table skills?+
The test uses worksheet pictures to assess whether candidates can work with tables and pivot tables as part of spreadsheet data tasks. It also checks formulas such as lookup and conditional functions, plus formatting choices including number formats, conditional formatting and charts. Review those results as evidence to discuss alongside a work sample and interview.
Bài kiểm tra liên quan
Google Sheets
10 phút, Kỹ năng phần mềm
Khám pháMicrosoft Word
12 phút, Kỹ năng phần mềm
Khám pháBài tập Google Sheets
60 phút, Kỹ năng phần mềm
Khám pháGoogle Docs
10 phút, Kỹ năng phần mềm
Khám pháMicrosoft 365
11 phút, Kỹ năng phần mềm
Khám pháMicrosoft PowerPoint
10 phút, Kỹ năng phần mềm
Khám pháSử dụng bài kiểm tra Microsoft Excel trung cấp trong đợt tuyển dụng tiếp theo
Mọi gói, kể cả Free, đều có đầy đủ thư viện bài kiểm tra.