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 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. Total Questions 55 Question Types Simulation Competencies Tested Formatting and EditingFormulasGeneral Commands and PropertiesInsert ToolsPage LayoutTools and Data Management Tasks Tested Open a WorkbookInsert a RowFont StyleFont SizeFormat Cells as CurrencySUM FunctionCopyPaste a FunctionSaveText AlignmentSelecting CellsBordersRenaming a WorksheetInsert ColumnUse AVERAGE FunctionColumn WidthInsert ChartChart StylesText WrapInsert WorksheetMerge and Center CellsSortMarginsPage OrientationHeader/FooterSpell CheckPrint Centered on PageCreate PivotTablePrint ScalingPrint WorksheetHide ColumnFreeze PanesConcatenateIF StatementSelect Non-Contiguous CellsPaste SpecialFill HandleConditional FormattingCustom SortTable StyleEdit PivotTablePivotTable FilterCreate PivotChartCreate a MacroRun a MacroTurn on AutoFilterApply FilterCell ReferencesConvert Text to ColumnsVLOOKUPCOUNTIFCreate a Custom ListSelect Multiple WorksheetsInsert Page BreakPrint Area
