The MS Excel (Office 365) skills test is a fast, easy way to confirm whether a candidate has an understanding of concepts underlying Microsoft Excel for Office 365. The test asks questions from a bank of questions for testing security purposes. HR Avatar periodically adds new questions to this bank to prevent cheating.

This test is fully mobile ready and operates on most modern mobile devices.

Specific topics covered within the test include:

• Accessing data from other sources
• Accessing spellcheck and thesaurus
• Applying basic cell arithmetic
• Changing page layout
• Collaborating and Sharing Files
• Common problems in spreadsheets
• Conditional formulas
• Converting text to columns
• Copying formulas
• Copying, cutting and pasting data
• Creating 2D charts from data
• Creating hyperlinks
• Creating, Opening, and Saving Files
• Formatting cell appearance
• Freezing rows and columns
• Inserting and viewing comments
• Protecting files and worksheets
• Recognizing when to use a spreadsheet
• Removing duplicate data
• Sorting and searching data
• Using common cell formulas
• Using VLOOKUP
• Viewing and recording macros
• Working with worksheets
• PivotTable Basics
• Fields

This non-interactive version consists of both text-based multiple choice and multiple correct answer questions. A software simulation is not included to ensure a smooth, uninterrupted testing process with no loss of measurement precision.

Note that while this skills assessment is a useful and efficient instrument for confirming a base level of skill or knowledge about this important topic, it is not intended to pinpoint the exact level of candidate or skill. We recommend that skills tests, like this one, be used in parallel with other measurements, such as cognitive ability, job fit, and behavioral history. Each different type of test provides a valuable piece of information you can use when evaluating potential job performance.