Excel Assessment Test: Practice Questions and Study Guide

We may earn a commission from some links on this page. Recommendations remain editorially independent.

Employers may use an Excel assessment test, also called an Excel skills test or Excel test for interview, to evaluate spreadsheet proficiency for administrative, data, finance, operations, HR, and analyst roles. This page sits under the Skills Assessment Tests hub and focuses on Excel as assigned by employers. There is no single universal Excel hiring test. Formats may be multiple-choice, interactive, task-based, adaptive, or interviewer-led.

A Microsoft Excel assessment usually means a skills test involving Microsoft Excel. It does not necessarily mean an assessment administered by Microsoft Corporation, a Microsoft hiring process, or a Microsoft Office Specialist (MOS) certification exam. Confirm the required Excel version, assessment provider, difficulty level, and test format in your invitation before you prepare.

The questions on this page are original practice-style exercises. They are not official Microsoft, Certiport, GMetrix, employer, recruiting-platform, or assessment-provider questions, and they do not reproduce a live hiring test. Always follow the instructions supplied by your employer or test provider.

Key Takeaways

• There is no universal Excel hiring test format, duration, task count, or passing score.
• Employer Excel screening is separate from Microsoft hiring and from MOS certification.
• Version and platform matter: Microsoft 365 Apps, perpetual Office releases, desktop, web, and macOS can differ.
• Practice questions on this page use U.S. English function names, comma argument separators, and period decimal separators.
• Do not use AI, bots, screen scraping, leaked workbooks, or proctoring bypass during a live assessment.

What Is an Excel Assessment Test?

An Excel assessment test evaluates spreadsheet knowledge or practical Excel ability. It may appear during recruitment, promotion, or training. This guide focuses on recruitment assessments. Exact content varies by employer and provider. Third-party preparation products are not official employer specifications.

Is There One Official Excel Assessment Test?

No. Assessments may differ by employer, job title, provider, Excel version, operating system, interface, difficulty label, timed or untimed delivery, and interactive or multiple-choice format.

Before you prepare, verify assessment name, provider, Excel version, permitted operating system, whether Excel must be installed locally, format, difficulty label, duration, task count, permitted materials, required score, retest policy, and accessibility accommodations. This page does not invent universal values for those items.

Excel Assessment Versus Microsoft Hiring and MOS

Excel employment testing versus related intents

Intent	What it usually means	What this guide covers
Employer Excel skills test	Role-specific spreadsheet screening by an employer or assessment vendor	Yes, primary focus
Microsoft Corporation hiring	Recruitment for jobs at Microsoft, which may use different assessments	No, keep separate
MOS Excel certification	Credential pathway through Microsoft and Certiport, currently including exam MO-210 for Excel Associate (Microsoft 365 Apps)	Distinction only, not exam prep ownership
GMetrix or Kenexa-style practice	Vendor practice or simulation formats that are not universal for every employer	Mentioned as non-universal context

Hiring tests measure role-specific spreadsheet proficiency. MOS certification validates skills against a defined certification objective. Employers may use their own tests regardless of certification. Buying a preparation pack does not automatically grant MOS certification. As of the official Microsoft Learn Excel Associate (Microsoft 365 Apps) certification page, exam MO-210 is the current Microsoft 365 Apps Excel Associate path. Older codes such as MO-200 (Office 2019) and legacy 77-series Excel exams should be treated as older or version-specific pathways, not interchangeable current standards for every candidate.

Kenexa, GMetrix, and similar platforms may deliver specific simulation formats. Not every Excel hiring test uses them. A GMetrix-style practice result is not automatically an employer hiring score.

Excel Test for an Interview

An interviewer may use a timed spreadsheet file, an interactive simulation, a multiple-choice test, a take-home exercise, a live screen-sharing task, or verbal questions about formulas and workflow. Do not treat one format as universal.

Basic, Intermediate, and Advanced Excel Tests

Treat these labels as practical preparation categories rather than universal standards.

Basic

Possible skills include workbook navigation, entering data, selecting cells, rows and columns, basic formatting, simple formulas, SUM, AVERAGE, COUNT, sorting, filtering, and printing.

Intermediate

Possible skills include relative and absolute references, IF, AND, OR, COUNTIF, SUMIF, conditional formatting, tables, charts, data validation, freeze panes, PivotTable basics, and lookup functions.

Advanced

Possible skills may include advanced lookup methods, nested logical formulas, PivotTables and PivotCharts, Power Query, complex data cleaning, what-if analysis, named ranges, dynamic arrays where supported, advanced error handling, and macros or VBA only when explicitly required. Do not assume macros, VBA, Power Query, or dynamic arrays appear on every advanced test. Feature availability can depend on Microsoft 365 Apps versus older perpetual versions, and on desktop versus Excel for the web.

Version and Platform Differences

Excel features differ among desktop, web, and mobile versions. Windows and macOS shortcuts may differ. Older Office releases may not support current functions such as XLOOKUP or some dynamic-array behaviors. Menus can change. Employer simulations may not behave exactly like desktop Excel. Locale settings can affect formula separators, decimal punctuation, and date display.

Do not install unsupported operating systems, Adobe Flash, or unverified training software to chase an old simulation. Follow the invitation for the platform you must use.

Some commercial Excel preparation packages state that they are not compatible with Apple operating systems. Confirm your employer platform and any paid product platform requirements separately at checkout.

For the practice questions below:

• use U.S. English function names;
• use commas between function arguments;
• use periods as decimal separators.

These conventions are practice assumptions for this page, not universal worldwide Excel rules.

Common Assessment Areas

Workbook and Worksheet Navigation

Workbooks, worksheets, cell addresses, active cells, ranges, rows and columns, inserting and deleting, renaming sheets, moving between worksheets, and freezing panes.

Data Entry and Editing

Entering values, editing cells, copying, filling, clearing content, undo and redo, Paste Special concepts, and text versus numeric values.

Formulas

Formulas beginning with =, arithmetic operators, operator precedence, parentheses, relative references, absolute references, mixed references, copying formulas, and common formula errors.

Core Functions

SUM, AVERAGE, MIN, MAX, COUNT, COUNTA, ROUND, IF, AND, OR, SUMIF, COUNTIF, and a lookup function appropriate to the stated version.

Sorting and Filtering

Single-column sorts, multi-level sorts, filtering, retaining complete records, header rows, custom criteria, and visible versus hidden rows.

Excel Tables

Converting a range to a table, header rows, structured data, total rows, automatic expansion, filtering, and consistent formulas.

Formatting

Number formats, dates, percentages, currency, decimal places, alignment, text wrapping, borders, cell styles, and Format Painter.

Conditional Formatting

Highlighting values, duplicates, thresholds, data bars, conceptual formula-based rules, and rule order.

Charts

Selecting an appropriate chart type, axes, legends, data series, titles, category comparisons, trends over time, and avoiding misleading scales.

PivotTables

Rows, columns, values, filters, summarizing data, refreshing, grouping, and choosing the correct aggregation.

Data Validation

Lists, whole-number limits, date limits, input restrictions, error alerts, and validation versus formatting.

Error Checking

#DIV/0!, #N/A, #VALUE!, #REF!, #NAME?, formula auditing, incorrect ranges, numbers stored as text, and inconsistent formulas.

Printing and Page Setup

Print area, orientation, margins, scaling, repeating headers, page breaks, and print preview.

Accessibility and Clear Spreadsheet Design

Descriptive headers, readable number formats, avoiding color-only meaning, consistent structure, meaningful worksheet names, and clear chart labels.

Security and Integrity Restrictions

This article does not provide instructions for bypassing assessment software, automating answers during a live hiring test, screen scraping a live assessment, using bots or external tools to complete a live assessment, defeating proctoring, accessing locked answer files, extracting proprietary question banks, formula injection against another system, hiding malicious macros, external data exfiltration, bypassing workbook protection, or obtaining leaked employer files.

Practice content uses fictional, non-sensitive datasets only.

Excel Assessment Practice Questions

Real Excel assessments may require you to perform tasks inside Excel or a simulated workbook. The questions below use a multiple-choice format so they can be completed in a web browser. They test the same underlying concepts but do not reproduce a live assessment interface.

Formulas use U.S. English names, comma argument separators, and period decimal separators.

Question 1

1. In a worksheet, which cell address is at column C and row 5?

A) R5C3

B) 5C

C) C5

D) C-5

Correct answer: C

Excel addresses use the column letter followed by the row number, so column C and row 5 is C5.

Question 2

2. How many cells are in the range A1:B3?

A) 3

B) 5

C) 9

D) 6

Correct answer: D

The range covers columns A-B (2 columns) and rows 1-3 (3 rows): 2 x 3 = 6 cells.

Question 3

3. You want row 1 to stay visible while scrolling down. Which action best matches that goal?

A) Hide row 1

B) Freeze the top row

C) Delete rows below row 1

D) Merge the entire worksheet

Correct answer: B

Freezing the top row keeps headers visible during vertical scrolling.

Question 4

4. A worksheet has headers in column A and values in column B. You insert a new column before column B. What happens to the original values that were in column B?

A) They shift right into column C

B) They stay in column B and overwrite the new column

C) They move to a new worksheet

D) They become absolute references automatically

Correct answer: A

Inserting a column before B shifts the existing column B content to the right.

Question 5

5. Which statement best describes a workbook?

A) A single cell only

B) A file that can contain one or more worksheets

C) A chart title

D) A print margin setting

Correct answer: B

A workbook is the Excel file container; it can hold multiple worksheets.

Question 6

6. What does =5+3*2 return?

A) 10

B) 16

C) 11

D) 13

Correct answer: C

Multiplication is evaluated before addition: 3*2=6, then 5+6=11.

Question 7

7. What does =2+6/2 return?

A) 4

B) 2

C) 8

D) 5

Correct answer: D

Division occurs before addition: 6/2=3, then 2+3=5.

Question 8

8. Cell D2 contains =B2+C2. If you copy that formula to D3, which formula results (relative references)?

A) =B3+C3

B) =B2+C2

C) =$B$2+$C$2

D) =B2+C3

Correct answer: A

Relative references adjust by the copy offset, so row 2 becomes row 3.

Question 9

9. Which formula keeps the reference to A1 fixed when copied?

A) =A1*B1

B) =$A$1*B1

C) =A$1*B1 only

D) =A1*$B1 only

Correct answer: B

$A$1 is an absolute reference to cell A1.

Question 10

10. In =A$1*B2, what kind of reference is A$1?

A) Fully relative

B) Fully absolute

C) Mixed: column can change, row is fixed

D) Invalid syntax

Correct answer: C

A$1 fixes the row and leaves the column relative, so it is a mixed reference.

Question 11

11. Which entry is a valid Excel formula?

A) SUM(A1:A3)

B) A1+A2

C) Total: A1+A2

D) =A1+A2

Correct answer: D

Formulas begin with an equals sign.

Question 12

12. You need the total of B2 through B6. Which formula uses the correct range?

A) =SUM(B2:B6)

B) =SUM(B2:B5)

C) =SUM(B3:B6)

D) =SUM(B2,B6)

Correct answer: A

B2:B6 includes all five required cells.

Question 13

13. Cells contain B2=4 and C2=7. What does =B2*C2 return?

A) 11

B) 28

C) 3

D) 47

Correct answer: B

4 x 7 = 28.

Question 14

Use this fictional range for the next function questions where noted:

Cell	Value
A1	10
A2	20
A3	30
A4	(blank)
A5	Text

14. What does =SUM(A1:A3) return?

A) 50

B) 70

C) 60

D) 0

Correct answer: C

10+20+30 = 60.

Question 15

15. Using the same values, what does =AVERAGE(A1:A3) return?

A) 15

B) 30

C) 60

D) 20

Correct answer: D

(10+20+30)/3 = 20.

Question 16

16. Using the same values, what does =COUNT(A1:A5) return?

A) 3

B) 4

C) 5

D) 2

Correct answer: A

COUNT counts numeric values only: 10, 20, and 30, so 3.

Question 17

17. Using the same values, what does =COUNTA(A1:A5) return?

A) 3

B) 4

C) 5

D) 2

Correct answer: B

COUNTA counts non-empty cells: 10, 20, 30, and Text, so 4.

Question 18

18. Using the same values, what does =MAX(A1:A3) return?

A) 10

B) 20

C) 30

D) 60

Correct answer: C

The largest numeric value among 10, 20, and 30 is 30.

Question 19

19. What does =ROUND(12.46,1) return?

A) 12.4

B) 12

C) 12.46

D) 12.5

Correct answer: D

Rounded to 1 decimal place, 12.46 becomes 12.5.

Question 20

20. Cell B2 contains 85. What does =IF(B2>=80,"Pass","Review") return?

A) Pass

B) Review

C) 85

D) TRUE

Correct answer: A

85 is greater than or equal to 80, so the formula returns Pass.

Question 21

21. Range D2:D5 contains 5, 8, 5, 12. What does =COUNTIF(D2:D5,5) return?

A) 1

B) 2

C) 3

D) 5

Correct answer: B

The value 5 appears twice, so COUNTIF returns 2.

Question 22

22. A table of employee records has Name, Department, and Hire Date. You sort only the Hire Date column from newest to oldest without expanding the selection. What is the main risk?

A) Dates become text

B) Filters are deleted forever

C) Rows can misalign so names and departments no longer match the correct hire dates

D) Absolute references become relative

Correct answer: C

Sorting one column alone can break record integrity across the row.

Question 23

23. You need Region A records listed before Region B, and within each region you need Sales from highest to lowest. Which approach is correct?

A) Sort Sales first ascending, then Region

B) Sort Sales only and hope Region follows

C) Filter Region only and ignore Sales

D) Sort by Region A to Z, then by Sales largest to smallest

Correct answer: D

A multi-level sort uses Region first, then Sales descending within each region.

Question 24

24. After applying a filter to show only Status = Open, which rows remain visible?

A) Only rows meeting the Open criterion

B) Every row including Closed

C) Only blank rows

D) Only the header row permanently

Correct answer: A

A filter hides rows that do not match the active criteria.

Question 25

25. Why should a header row be included when converting a range to an Excel Table?

A) Headers are never used

B) Tables use headers for field names, filtering, and structured organization

C) Headers convert numbers to text automatically

D) Headers disable sorting

Correct answer: B

Table headers identify each column for filtering and structured use.

Question 26

26. Which Excel Table feature best describes automatic expansion when you type adjacent to the table?

A) The workbook renames itself

B) All formulas become macros

C) The table range grows to include the new adjacent data

D) Conditional formatting is removed

Correct answer: C

Excel Tables typically expand to include new adjacent entries.

Question 27

27. Cell E2 contains 0.25 and is formatted as a percentage with 0 decimal places. What is displayed?

A) 0.25%

B) 1/4

C) 250%

D) 25%

Correct answer: D

0.25 as a percentage displays as 25%.

Question 28

28. Which number format is most appropriate for a column of invoice amounts in U.S. dollars?

A) Currency or Accounting

B) General only

C) Text

D) Scientific

Correct answer: A

Currency or Accounting formats present money values clearly.

Question 29

29. You need values shown with exactly two digits after the decimal. Which action is most direct?

A) Increase indent

B) Set the number format to 2 decimal places

C) Wrap text

D) Freeze panes

Correct answer: B

Number formatting controls displayed decimal places.

Question 30

30. Long labels in A1 are cut off visually. Which formatting option shows the full text within the cell width by wrapping?

A) Merge and center only

B) Decrease decimal

C) Wrap Text

D) Hide the column

Correct answer: C

Wrap Text displays content on multiple lines inside the cell.

Question 31

31. You want every value greater than 100 in a score column highlighted in yellow. Which tool fits best?

A) Data Validation list

B) Print Area

C) Paste Special Values

D) Conditional Formatting highlight-cell rule

Correct answer: D

Conditional Formatting can highlight cells that meet a numeric threshold.

Question 32

32. You want to compare sales totals across five product categories in one period. Which chart type is usually most appropriate?

A) Clustered column or bar chart

B) Pie chart with 40 tiny slices and no labels

C) Surface chart

D) Stock chart

Correct answer: A

Column or bar charts compare category totals clearly.

Question 33

33. A line chart’s vertical axis begins at 90 instead of 0 for values ranging from 92 to 100. What is the main communication risk?

A) The chart cannot print

B) Small differences can look exaggerated

C) Formulas stop calculating

D) Filters become absolute references

Correct answer: B

A truncated axis can visually exaggerate relatively small changes.

Question 34

34. In a PivotTable Field List, you place Region in Rows and Amount in Values. What does each row typically represent?

A) One formula only

B) A chart title

C) A Region summarized with an Amount aggregation

D) A print margin

Correct answer: C

Row fields create groupings; Values summarize Amount for each Region.

Question 35

35. Source data for a PivotTable was updated, but the PivotTable still shows old totals. What should you do first?

A) Delete the workbook

B) Turn off Autofilter permanently

C) Convert all numbers to text

D) Refresh the PivotTable

Correct answer: D

Refreshing recalculates the PivotTable from the current source data.

Question 36

36. You need average units per Region in a PivotTable Values area. Which aggregation is appropriate?

A) Change the value field setting to Average

B) Count uniquely by selecting Sum only

C) Use Merge Cells in the PivotTable body

D) Use Freeze Panes inside the PivotTable

Correct answer: A

Average is the aggregation that reports mean units.

Question 37

37. You want users to choose a department only from Admin, Sales, or Ops. Which feature fits best?

A) Conditional Formatting data bars

B) Data Validation list

C) Sparkline

D) Watch Window

Correct answer: B

A Data Validation list restricts entries to specified choices.

Question 38

38. Data Validation is set to whole numbers between 1 and 10 inclusive. Which entry should be rejected?

A) 5

B) 10

C) 0

D) 1

Correct answer: C

0 is outside the inclusive 1-10 limit.

Question 39

39. What does #DIV/0! usually mean?

A) A chart legend is missing

B) A filter is turned on

C) A print area is too large

D) A formula divides by zero or an empty denominator

Correct answer: D

Division by zero produces the #DIV/0! error.

Question 40

40. A formula shows #REF! after rows were deleted. What does that error indicate?

A) The formula refers to a cell that is no longer valid

B) The formula name is unknown

C) The number format is currency

D) The worksheet is protected

Correct answer: A

#REF! means a referenced cell is invalid or deleted.

Question 41

41. You need only columns A through F printed on one landscape page. Which setup choices are most relevant?

A) Hide formulas only

B) Set print area to A:F, choose landscape, and usually Fit to 1 page wide

C) Convert the sheet to a PivotChart

D) Clear all number formats

Correct answer: B

Print area, orientation, and scaling control how the selected columns print.

Question 42

Applied dataset (fictional)

Row	Item	Qty	UnitPrice	Status
2	Binder	3	4	Open
3	Pen	10	1	Closed
4	Binder	2	4	Open
5	Clip	5	2	Open

42. Which formula correctly calculates the line total for row 2 (Qty x UnitPrice)?

A) =C2+D2

B) =SUM(C2:D5)

C) =C2*D2

D) =C2/D2

Correct answer: C

Line total is quantity times unit price: C2D2 = 34 = 12.

Question 43

43. Using the same dataset, which formula counts Open rows in Status (E2:E5)?

A) =COUNTIF(E2:E5,“Closed”)

B) =COUNTA(E2:E5)

C) =SUM(E2:E5)

D) =COUNTIF(E2:E5,“Open”)

Correct answer: D

COUNTIF with criterion Open returns 3 matching rows (rows 2, 4, and 5).

Question 44

44. Using the same dataset, which workflow best finds the total Qty for Binder items only?

A) Use SUMIF on Item for “Binder” over Qty, or filter Item=Binder and sum visible Qty carefully

B) Manually sum every Qty without checking Item

C) Sort Status only

D) Create a pie chart and guess

Correct answer: A

SUMIF (or an equivalent filtered sum) limits the total to Binder rows: 3+2 = 5.

Question 45

45. A coworker enters Binder quantities as text that looks numeric. Totals using SUM appear too low. What is the most likely issue?

A) Numbers stored as text are ignored by SUM

B) Freeze Panes is enabled

C) The chart type is wrong

D) Print titles are missing

Correct answer: A

SUM ignores text values, so numbers stored as text understate totals.

Practice Answer Key

1. C
2. D
3. B
4. A
5. B
6. C
7. D
8. A
9. B
10. C
11. D
12. A
13. B
14. C
15. D
16. A
17. B
18. C
19. D
20. A
21. B
22. C
23. D
24. A
25. B
26. C
27. D
28. A
29. B
30. C
31. D
32. A
33. B
34. C
35. D
36. A
37. B
38. C
39. D
40. A
41. B
42. C
43. D
44. A
45. A

How to Score This Practice Test

• 41-45 correct: Strong baseline
• 35-40 correct: Good readiness
• 27-34 correct: Moderate readiness
• 18-26 correct: Needs improvement
• 17 or fewer correct: Start with fundamentals

This scoring guide applies only to the unofficial practice questions on this page. It is not an official employer score, Microsoft score, MOS score, Certiport result, GMetrix score, passing threshold, interview decision, certification result, or employment decision.

How to Prepare for an Excel Assessment Test

1. Confirm the assessment provider.
2. Confirm whether the test is interactive or multiple-choice.
3. Identify the required Excel version.
4. Confirm whether the test uses Windows, macOS, or a browser simulation.
5. Determine the required difficulty level.
6. Review workbook and worksheet navigation.
7. Review basic formulas.
8. Practise relative and absolute references.
9. Review core functions.
10. Practise sorting and filtering.
11. Review tables and structured data.
12. Practise formatting and number formats.
13. Review conditional formatting.
14. Practise charts.
15. Review PivotTables.
16. Practise data validation and error checking.
17. Complete hands-on exercises in a blank workbook.
18. Complete static conceptual questions.
19. Add timed practice only after building accuracy.
20. Follow the employer’s official test instructions.

Verify version, operating system, provider, test format, level, duration, number of tasks, permitted resources, locale rules, shortcut acceptance, passing rule, retest policy, and accessibility process from your invitation. Do not invent those details.

If your hiring process also includes a broader Office battery, see the Microsoft Office Assessment Test guide. For document-focused practice separate from spreadsheets, see the Microsoft Word Assessment Test guide.

Optional Third-Party Practice

JobTestPrep Excel-style practice can support familiarization with spreadsheet tasks and related Office training materials as an independent commercial option. Live product pages may emphasize MOS-oriented courses, GMetrix-linked practice, version-specific modules, licence length, and platform limits such as Apple incompatibility. Confirm what is free versus paid at checkout. It is not Microsoft, Certiport, GMetrix, an employer, or an official assessment administrator, and it does not grant MOS certification by itself.

Common Mistakes

• assuming every Excel assessment uses the same interface;
• preparing for a MOS certification exam when the employer uses a basic hiring test;
• assuming Microsoft itself administers the assessment;
• treating a third-party prep pack as the official assessment source;
• assuming 80% is a universal passing score;
• practising only theoretical questions for an interactive test;
• practising only hands-on tasks for a multiple-choice test;
• using the wrong Excel version;
• overlooking macOS and Windows differences;
• forgetting the = at the beginning of a formula;
• confusing relative and absolute references;
• selecting an incomplete range;
• sorting one column without the rest of the record;
• misunderstanding blank cells in COUNT and COUNTA;
• using percentage formatting incorrectly;
• choosing the wrong chart type;
• forgetting to refresh a PivotTable;
• using formatting instead of validation;
• overlooking numbers stored as text;
• failing to check formula results;
• relying on shortcuts unsupported by the assessment simulator;
• trying to automate or bypass the live test;
• treating a practice score as an employment prediction.

Official Microsoft and Certification Resources

• Microsoft Excel Help and Learning
• Microsoft Support: Overview of formulas in Excel
• Microsoft Learn: MOS Excel Associate (Microsoft 365 Apps)
• Certiport: Microsoft Office Specialist overview

Microsoft Support is authoritative for Excel feature behavior. Current Microsoft and Certiport pages control certification information. Certification objectives are not the universal content of employer assessments. Retired or version-specific exam codes must be labeled accurately.

For ranked-response or work-style sections, assessment test preparation may also be useful when you need extra drills under time pressure.

Related Internal Guides

• Skills Assessment Tests
• Microsoft Office Assessment Test
• Microsoft Word Assessment Test
• Microsoft PowerPoint Assessment Test
• Data Entry Practice Test
• Typing Test
• Clerical Skills Test
• Employer Assessment Tests
• Numerical Reasoning
• Office Technician Exam
• Administrative Assistant Exam

FAQ