Go to Home Page
MS Excel 2019 (Office 365)

MS Excel 2019 (Office 365)

Skills/Knowledge Assessment (Test)

Back

The MS Excel 2019 (Office 365) skills test is a fast, easy way to confirm whether a candidate has an understanding of concepts underlying Microsoft Excel 2019. 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.

Note that users of Office 365 utilize the latest versions of Microsoft Office products. For Excel this is currently Excel 2019.

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 Excel-compatible file types
  • 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

The test consists of both text-based multiple choice and simulation-based performance questions, where the candidate is asked to perform tasks on a simulated MS Excel 2019 interface.

Note that while the Excel 2019 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.

Language:US English
Time to Complete:15 Minutes (Approximately)
Specifications:Desktop, Laptop, Tablet, Mobile (any device with an internet browser)


(HR Avatar Use Only) pid=1848, Sim

 
Sign In  to administer this test.

Read the Reviews
Read HR Avatar reviews on G2
"Amazing Service and Spot-On Testing"
"The value received far exceeds the price"
"Truly takes out the guess work"
"Hiring managers can easily understand the reports"

Related Products   Back
Abstract Reasoning
Evaluates a candidate's ability to work with abstract concepts and to recognize spatial patterns.
Account Manager
Based on O*NET SOC 43-4051.00, the Account Manager test includes a work simulation set in a Medium-Level General Busine...
Account Manager (Short plus Video Interview)
The Account Manager (Short plus Video Interview) test includes a short virtual ...
Account Manager (Short)
Job Specific, Whole Person (CT6) coming soon.
URL Copied to your Clipboard.

The URL to return to this page has been copied to your clipboard so you can share it or save it as needed.


Go to Home Page
This website uses cookies to ensure you get the best experience on our website. Learn More