877-496-4200

Microsoft Office Skills Tests

There are 3 versions of each test to choose from: Basic, Standard and Advanced

  • Basic: Consists of 30 to 35 test questions that cover beginner level questions only. Saving, Printing, Copying, Pasting, Bolding, etc.
  • Standard & Intermediate (2013 & 2016): The standard and intermediate test is our most popular version. It consists of 30 to 35 questions that cover beginner, intermediate and advanced level questions all in one test. It's designed to show you their depth of knowledge within that application. The easy to read report will show you how well they did at each level.
  • Advanced: Consists of 30 to 35 test questions that cover advanced level questions only. This is a great test to use if you need an employee with high level skills. Macros, Formulas, Tables, etc. 

Access - Standard 2007, 2010 or Intermediate 2013

Attitudes & Aptitudes  Duration/ Items Description

n/a

35 Questions - Approx 25 minutes

Access Standard test includes beginner, intermediate and advanced level questions.  A few of the topics covered: 

  • Create a Database with Wizard
  • Data Type - Date
  • Date Format
  • Input Mask
  • Lookup Fields
  • Edit Data
  • Add Data Table to Query
  • Create New Form with Autoform
  • Form Font
  • Form Data Entry
  • Report Calculation
  • & More...

Access - Basic 2007, 2010 or 2013

Attitudes & Aptitudes  Duration/ Items Description

n/a

37 Questions

Topics Covered Include: Open Database, Importing Data, Save Filter as a Query, Edit Data, Hide Columns, etc. 

Untimed (approx 25 minutes) - 37 Questions

Access - Advanced 2007, 2010 or 2013

Attitudes & Aptitudes  Duration/ Items Description

n/a

33 Questions

Topics Covered Include: Forms Options, Encoding Database, Aligning Form Elements, Creating Crosstab Query, Expression Editor, etc.

 

Untimed (approx 30 minutes) - 33 Questions

Excel - Basic 2007, 2010 or 2013

Attitudes & Aptitudes  Duration/ Items Description

n/a

32 Questions

Topics Covered Include: Copy Cells, Insert Row, Align Cells, Autofit Columns, Save Workbook, etc. 

Untimed (approx. 25 minutes) - 32 Questions

Excel - Advanced 2007, 2010 or 2013

Attitudes & Aptitudes  Duration/ Items Description

n/a

34 Questions

Topics Covered Include: Macros, PivotTable, Sorting, Charts, Conditional Formatting, Range Names, etc, 

  • Untimed (approx. 30 minutes).  This test measures only Advanced areas of Excel and should be used where positions require higher level knowledge of Excel.   We recommend demoing this test before administering as it is very challenging.   A few of the topics covered: Absolute Cell References
  • Pivot Table - Slicer
  • Customize the Ribbon
  • Modify chart data lables
  • Save to Skydrive
  • Insert Page Break
  • Use Goal Seek
  • Create a Column Chart
  • Create Formula using AVERAGE function
  • Modify a Chart Axis
  • & More...

Outlook - Standard 2007, 2010 or Intermediate 2013

Attitudes & Aptitudes  Duration/ Items Description

n/a

20 Questions - Approx 18 minutes

The Standard Outlook test measures commonly used functions of Outlook.  A few of the topics covered:

  • Calendar View
  • Adding Appointments
  • Meeting Planner
  • Adding Contacts
  • Sorting Email
  • Open Email
  • Return Receipt
  • Rules Wizard
  • Sent Items
  • Journal
  • & More...

PowerPoint - Standard 2007, 2010 or Intermediate 2013

Attitudes & Aptitudes  Duration/ Items Description

n/a

35 Questions - Approx 25 minutes

The PowerPoint Standard test includes beginner, intermediate and advanced questions.  This test is designed to show the depth of knowledge in PowerPoint.  A few of the topics covered are: 

  • Creating a New Presentation
  • Deleting a Slide
  • Changing Layout
  • Applying Style
  • Modifying Font
  • Resizing Graphic
  • Converting test to a SmartArt Graphic
  • Apply a Transition Effect
  • Adding a Background
  • Printing
  • Broadcasting a Slideshow
  • & More...

PowerPoint - Basic 2007, 2010 or 2013

Attitudes & Aptitudes  Duration/ Items Description

n/a

29 Questions

Topics Covered Include: Cutting Objects, Save, Slide Orientation, Timed Slide Show, Justify Text, etc. 

Untimed (approx. 25 minutes) - 29 Questions

PowerPoint - Advanced 2007, 2010 or 2013

Attitudes & Aptitudes  Duration/ Items Description

n/a

33 Questions

Topics Covered Include: Macros, Updating Links, Animation, Numbering, Slide Show, Auto Shapes, Scale Graphics, etc. 

Untimed (approx 25 minutes) - 33 Questions

Windows 7 - Standard

Attitudes & Aptitudes  Duration/ Items Description

n/a

35 Questions

Topics Covered Include: Creating Folders, Open Programs, Shut Down, Minimize Windows, Find, etc 

Untimed (approx 25 minutes) - 35 Questions

Word - Basic 2007, 2010 or 2013

Attitudes & Aptitudes  Duration/ Items Description

n/a

30 Questions

Topics Covered Include: Copy & Paste, Line Spacing, Margins, Redo, Bold, Fonts, Saving Documents, etc. 

Untimed (approx 25 minutes) - 30 Questions

Word - Advanced 2007, 2010 or 2013

Attitudes & Aptitudes  Duration/ Items Description

n/a

37 Questions

Topics Covered Include: Macros, Field Codes, AutoText, Bookmarks, Tables, Mail Merge, Footnotes, etc. 

Untimed (approx 25-30 minutes) - 37 Questions

Basic Computer Literacy

Attitudes & Aptitudes  Duration/ Items Description

n/a

Topics include Basic skills of using a mouse, minimize, maximize, menus and navigation on a computer.

Excel - Functions/Formulas 2013

Attitudes & Aptitudes  Duration/ Items Description

Approx 25 minutes

Excel Functions/Formulas covers areas

  • VLookup
  • Average
  • SumIf
  • Payment
  • Internal Rate of Return
  • PivotTable
  • Interest Payment
  • Count
  • & more


 

Questions?

Technical Requirements for Test