Microsoft Excel 2016 - Power User Assessment
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) |