Mastering Excel 2016 (MOS) – Intermediate

If you have a spreadsheet with a formula using cell references, where can you go to change the cell reference in the formula to an existing Named Range?

An example of a logical function that produces a True or False answer is:

To display the formulas in worksheet cells:

Filtering removes the data that doesn’t fit the filter criteria.

Use DSUM if you want to:

What is the first step in using the Subtotal feature in Excel?

Clean data in Excel databases refers to:

Conditional Formatting is found:

Which keyboard shortcut creates a default column chart?

When a chart is selected, three option buttons show up to the right of the chart and help you manipulate the chart’s appearance. These are called:

When determining how to set up a PivotTable, a good rule is to put your primary question in the:

In the PivotChart Fields pane, the Axis is similar to the __________ in the PivotTable Fields pane.