Microsoft Excel 2007 is the spreadsheet component of the Microsoft Office 2007 suite. The Excel 2007 assessment 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: Knowledge Worker, Computer User
Localizations Available: US English
Average Testing Time (minutes): 35
Time Allowed (minutes): 35
Number of Questions: 30
Designed for Remote Testing: Yes
Question Format: Simulation, Multiple
Choice Product Category: Software Skills
This test measures skills in using a spreadsheet application.
Test Topics Questions / Topic
Creating and Analyzing Data 9
Formatting Data and Content 9
Managing Workbooks and Worksheets 7
Printing and Views 5