Microsoft Excel 2016 Tutorial Assessment

$16.00

Microsoft Excel 2016 Tutorial Assessment

$16.00
description

Microsoft Excel 2016 is a popular spreadsheet application. It is included in the Microsoft Office Package, which also offers Word and PowerPoint. The first half of the Microsoft Excel 2016 Tutorial is designed to offer instruction to clerical-level users of Excel who are required to edit, develop, and create Excel Workbooks. This tutorial improves 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 second half of the tutorial provides examples intended to familiarize the user with the full functionality of the software. The primary topics include advanced formatting and formula writing. This part of the tutorial targets those who will be required to use some of the more advanced features of the program, though the bulk of their responsibilities may fall within conducting more basic level activities.

 

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