Office Clerical Skills Testing Software Intermediate Microsoft Excel Test
 
Biddle Consulting Group, Inc.
     
products > opac > opac tests > intermediate microsoft excel

OPAC® Pre-Employment Skills Testing Software
Intermediate Microsoft® Excel® :: Test Description

Description
  • The Intermediate Microsoft Excel test measures the ability to manipulate financial data and text using Excel's most essential features. The specific objectives of this test involve formatting, editing, sorting, modifying text, and using formulas within spreadsheets. An intermediate level of skill is required for successful test performance due to the complexity of questions, which often require multiple steps to answer correctly.
Software Applications Tested
  • Microsoft Excel 2000/XP/2003/2007
# of Tests Included
  • Three (3) test versions
KSAs Measured
  • Skill in sorting data according to criteria that will organize the data in various structures.
  • Skill in adding headers to an existing Microsoft® Excel document.
  • Skill in creating/moving existing worksheets.
  • Skill in creating charts using data provided in an existing Microsoft® Excel document.
  • Skill in renaming worksheets to custom naming conventions.
  • Skill in inserting comments on cells within an existing Microsoft® Excel document.
  • Skill in hiding and unhiding rows within an existing Microsoft® Excel document.

Call OPAC Testing Software today at 800.999.0438 ext. 248