Microsoft Excel 2016 - Power User Assessment

  • $10.00


The Microsoft Excel 2016 - Power User assessment attempts to provide the basis for separating candidates who possess limited exposure to Microsoft Excel 2016 from those who are conversant with the full functionality of the software. The primary topics include advanced formatting and formula writing. This assessment is designed to validate candidates who will be required to use some of the more advanced features of the program on a regular basis.

Number of questions 25
Test format Software Simulation
Time to complete Varies by skill
Topics covered Formatting and Editing
Formulas
General Commands and Properties
Insert Tools
Page Layout
Tools and Data Management
Tasks tested Apply Filter
Cell References
Concatenate
Conditional Formatting
Convert Text to Columns
COUNTIF
Create a Custom List
Create a Macro
Create PivotChart
Custom Sort
Edit PivotTable
Fill Handle
Freeze Panes
Hide Column
IF Statement
Insert Page Break
Paste Special
PivotTable Filter
Print Area
Run a Macro
Select Multiple Worksheets
Select Non-Contiguous Cells
Table Style
Turn on AutoFilter
VLOOKUP
Supported languages ๐Ÿ‡บ๐Ÿ‡ธ English (en_US)

We Also Recommend