Microsoft Excel 2016 - Whole Assessment

  • $10.00


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 - Normal User assessment is designed to validate clerical level users of Excel who are required to edit, develop, and create Excel Workbooks. This assessment assesses the user's ability to create and develop a basic Excel workbook, including the most commonly used commands for formatting cells, navigation through the application, using formulas, and changing the overall appearance of the spreadsheet. 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 55
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
Borders
Cell References
Chart Styles
Column Width
Concatenate
Conditional Formatting
Convert Text to Columns
Copy
COUNTIF
Create a Custom List
Create a Macro
Create PivotChart
Create PivotTable
Custom Sort
Edit PivotTable
Fill Handle
Font Size
Font Style
Format Cells as Currency
Freeze Panes
Header/Footer
Hide Column
IF Statement
Insert a Row
Insert Chart
Insert Column
Insert Page Break
Insert Worksheet
Margins
Merge and Center Cells
Open a Workbook
Page Orientation
Paste a Function
Paste Special
PivotTable Filter
Print Area
Print Centered on Page
Print Scaling
Print Worksheet
Renaming a Worksheet
Run a Macro
Save
Select Multiple Worksheets
Select Non-Contiguous Cells
Selecting Cells
Sort
Spell Check
SUM Function
Table Style
Text Alignment
Text Wrap
Turn on AutoFilter
Use AVERAGE Function
VLOOKUP
Supported languages 🇺🇸 English (en_US)

We Also Recommend