Recall at least three shortcuts to improve your speed.

Recognize which feature allows you to control what a user can type into a cell.

Identify the feature that enables you to name cells and ranges.

Determine why the SUBTOTAL function is preferred to the SUM function in many situations.

Identify a technique that helps ensure that a new row inserted between the last data row and the formula row is included in the total row formula.

Recognize at least three workbook design principles.

Identify the keyboard shortcut for evaluating formula text.

Recall the arguments for the SUMIFS function.

Recognize the Excel feature that removes duplicate values within a range.

Identify which Excel function can be used to perform a multicolumn list comparison.

Determine which approach to indenting report labels is recommended for recurring use workbooks.

Recall which Excel function returns the count of the number of cells that meet specified conditions.

Identify which Excel function can be used to return the last day of the month.

Recall the arguments of the DATE function.

Determine an Excel function that returns the year of the date.

Identify which function can help build dynamic report headers.

Recall a technique that helps Excel translate a data label to a report label.

Recognize which feature can be used to provide a filter for dynamic digital reports.

State the process to create a PivotTable report.

Identify the four PivotTable report layout areas.

State which type of PivotTable field will create report filters.

Identify the three PivotTable report layout formats.

Recall the operator that causes Excel to create absolute, structured table references.

Distinguish between calculated fields and calculated items.

State the process for displaying PivotTable report values as a percentage of the report total.

Identify the default sort order of a PivotTable.

Recall three ways to filter a PivotTable report.

State the process for creating a PivotChart.

Recognize the option that imports external data directly into a PivotTable.

Recall which Excel feature creates a chart within a single worksheet cell.