Microsoft Excel 2016 - Power User [Timed] Assessment

$16.00

Microsoft Excel 2016 - Power User [Timed] Assessment

$16.00
description

This assessment has a time limit of 60 minutes.

Microsoft Excel 2016 is a popular spreadsheet application. It is included in the Microsoft Office Package, which also includes Word and PowerPoint. The Microsoft Excel 2016 - Whole Test combines both the Normal and Power User Test. 

The Microsoft Excel 2016 - Power User [Timed] test 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 test is designed to test candidates who will be required to use some of the more advanced features of the program on a regular basis.

 

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 Concatenate
IF Statement
Conditional Formatting
Create PivotChart
Create a Macro
Cell References
VLOOKUP
COUNTIF
Create a Custom List
Freeze Panes
Paste Special
Fill Handle
Edit PivotTable
PivotTable Filter
Apply Filter
Hide Column
Custom Sort
Table Style
Select Non-Contiguous Cells
Select Multiple Worksheets
Insert Page Break
Run a Macro
Turn on AutoFilter
Convert Text to Columns
Print Area