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