Microsoft Excel 2010 - Power User Assessment

$16.00

Microsoft Excel 2010 - Power User Assessment

$16.00
description

The Microsoft Excel 2010 - Power User test attempts to provide the basis for separating candidates who possess limited exposure to Microsoft Excel 2010 from those who are conversant with the full functionality of the software. The primary topics include advanced formatting and formula writing. This test is designed to test candidates who will be required to use some of the more advanced features of the program, while the bulk of their responsibilities fall within conducting more basic level activities.

 

Total Questions 25
Question Types Simulation
Competencies Tested Formatting and Editing
Formulas
General Commands and Properties
Insert Tools
Page Layout
Tools and Data Management
Tasks Tested Hide Column
Select Non-Contiguous Cells
Custom Sort
Table Style
Run a Macro
Turn on AutoFilter
Convert Text to Columns
Select Multiple Worksheets
Insert Page Break
Print Area
Freeze Panes
Concatenate
IF Statement
Paste Special
Fill Handle
Conditional Formatting
Edit PivotTable
PivotTable Filter
Create PivotChart
Create a Macro
Apply Filter
Cell References
VLOOKUP
COUNTIF
Create a Custom List