Microsoft Excel 2007 is the spreadsheet component of the Microsoft Office 2007 suite. This adaptive test measures the candidate’s knowledge of Excel 2007. Designed for experienced users, this test includes the following topics: Charts, Data Entry, Data Manipulation, Formulas/Functions, Graphics, Software Interface, VBA Interface, and Web Interface. It evaluates the candidate’s experience in sorting and filtering data, entering basic formulas, modifying cell formatting and content, inserting and labeling charts, using templates, saving workbooks for earlier versions of Excel, viewing and printing workbooks, managing workbooks and worksheets, adding headers, footers and page breaks, creating and labeling charts and pivot tables, using conditional formatting and conditional statements, setting a print area, configuring worksheet protection settings, creating hyperlinks, and importing data.
Job Level: Individual Contributor
Job Family/Title: Computer End Users
Localizations Available: US English
Average Testing Time (minutes): 21
Time Allowed (minutes): 90
Number of Questions: 30
Designed for Remote Testing: Yes
Question Format: Simulation, Multiple Choice, Adaptive
Choice Product Category: Software Skills
This test measures skills in using a spreadsheet application.