Microsoft Excel 2010 - Power User Assessment

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 EditingFormulasGeneral Commands and PropertiesInsert ToolsPage LayoutTools and Data Management Tasks Tested Hide ColumnSelect Non-Contiguous CellsCustom SortTable StyleRun a MacroTurn on AutoFilterConvert Text to ColumnsSelect Multiple WorksheetsInsert Page BreakPrint AreaFreeze PanesConcatenateIF StatementPaste SpecialFill HandleConditional FormattingEdit PivotTablePivotTable FilterCreate PivotChartCreate a MacroApply FilterCell ReferencesVLOOKUPCOUNTIFCreate a Custom List