Microsoft Excel 2019 - Whole Test Assessment

$16.00

Microsoft Excel 2019 - Whole Test Assessment

$16.00
description

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 2019 - Whole Test combines both the Normal and Power User Test. The Microsoft Excel 2016 - Normal User test is designed to test clerical level users of Excel who are required to edit, develop, and create Excel Workbooks. This test 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 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.

 

Number of questions 55
Competencies tested General Commands and Properties
Formatting and Editing
Formulas
Insert Tools
Page Layout
Tools and Data Management
Tasks tested Open a Workbook
Insert a Row
Font Style
Font Size
Format Cells as Currency
SUM Function
Copy
Paste a Function
Save
Text Alignment
Selecting Cells
Borders
Renaming a Worksheet
Insert Column
Use AVERAGE Function
Column Width
Insert Chart
Chart Styles
Text Wrap
Insert Worksheet
Merge and Center Cells
Sort
Margins
Page Orientation
Header/Footer
Spell Check
Print Centered on Page
Create PivotTable
Print Scaling
Print Worksheet
Hide Column
Freeze Panes
Concatenate
IF Statement
Select Non-Contiguous Cells
Paste Special
Fill Handle
Conditional Formatting
Custom Sort
Table Style
Edit PivotTable
PivotTable Filter
Create PivotChart
Create a Macro
Run a Macro
Turn on AutoFilter
Apply Filter
Cell References
Convert Text to Columns
VLOOKUP
COUNTIF
Create a Custom List
Select Multiple Worksheets
Insert Page Break
Print Area