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. Total Questions 55 Question Types Simulation Competencies Tested Formatting and EditingFormulasGeneral Commands and PropertiesInsert ToolsPage LayoutTools and Data Management Tasks Tested Use AVERAGE FunctionMerge and Center CellsPrint Centered on PageCreate PivotTableConcatenateIF StatementConditional FormattingCreate PivotChartCreate a MacroCell ReferencesVLOOKUPCOUNTIFCreate a Custom ListSUM FunctionBordersColumn WidthInsert ChartText WrapSortHeader/FooterPrint ScalingFreeze PanesPaste SpecialFill HandleEdit PivotTablePivotTable FilterApply FilterInsert a RowFont StyleFont SizeFormat Cells as CurrencyCopyPaste a FunctionText AlignmentInsert ColumnHide ColumnCustom SortTable StyleOpen a WorkbookSaveSelecting CellsRenaming a WorksheetInsert WorksheetSpell CheckPrint WorksheetSelect Non-Contiguous CellsSelect Multiple WorksheetsChart StylesMarginsPage OrientationInsert Page BreakRun a MacroTurn on AutoFilterConvert Text to ColumnsPrint Area
