Knowledge Assessment Survey

This objective may include but is not limited to: setting advanced properties, saving a workbook as a template, and importing and exporting XML data.

This objective may include but is not limited to: protecting the current sheet, protecting the workbook structure, restricting permissions, and requiring a password to open a workbook.

This objective may include but is not limited to: merging workbooks and setting Track Changes options.

This objective may include but is not limited to: tracing formula precedents, dependents, and errors, locating invalid data or formulas, and correcting errors in formulas.

This objective may include but is not limited to: setting iterative calculation options and enabling or disabling automatic workbook calculation.

This objective may include but is not limited to: using an array formula and using a SUMIFS function.

This objective may include but is not limited to: finding and correcting errors in functions, applying arrays to functions, and using Statistical, Date and Time, Financial, Text, and Cube functions.

This objective may include but is not limited to: using Trend lines, Dual axes, chart templates, and Sparklines.

This objective may include but is not limited to: using automated analysis tools and performing What-If analysis.

This objective may include but is not limited to: manipulating PivotTable data and using the slicer to filter and segment your PivotTable data in multiple layers.

This objective may include but is not limited to: creating, manipulating, and analyzing PivotChart data.

This objective may include but is not limited to: choosing data sets from external data connections.

This objective may include but is not limited to: running a macro, running a macro when a workbook is opened, running a macro when a button is clicked, recording an action macro, assigning a macro to a command button, creating a custom macro button on the Quick Access Toolbar, and applying modifications to a macro.

This objective may include but is not limited to: inserting form controls and setting form properties.